Y
yccheok
Hi,
I try to change the following source text
"A",1,234,567,890,"A",123,456
"A",1,234,567,"A",123,456
"A",1,234,"A",123,456
"A",3,"A",123,456
i wish to change to
"A",1234567890,"A",123,456
"A",1234567,"A",123,456
"A",1234,"A",123,456
"A",3,"A",123,456
By using the following regular expression :-
",(\d{1,3})(,(\d{3}))+,"
and the replacement
",$1$3,"
Here is the result I obtain :-
"A",1890,"A"
"A",1567,"A"
"A",1234,"A"
"A",3,"A"
It seem that, I wish to have one or more $3. How can I specific that
in my code?
Thanks!
I try to change the following source text
"A",1,234,567,890,"A",123,456
"A",1,234,567,"A",123,456
"A",1,234,"A",123,456
"A",3,"A",123,456
i wish to change to
"A",1234567890,"A",123,456
"A",1234567,"A",123,456
"A",1234,"A",123,456
"A",3,"A",123,456
By using the following regular expression :-
",(\d{1,3})(,(\d{3}))+,"
and the replacement
",$1$3,"
Here is the result I obtain :-
"A",1890,"A"
"A",1567,"A"
"A",1234,"A"
"A",3,"A"
It seem that, I wish to have one or more $3. How can I specific that
in my code?
Thanks!