Replace string with modified string

Question

I have a file with 1000's of rows looking like

"20140611","20:19","C","IT","IT","HDR","HDPDIT","675605","000000135.97"," ..........

I am trying to replace all occurrences of string that matches this pattern : quote then 6 numerics followed by a closing quote ( i.e. "675605" with "675605@")

Using edit plus regular expression search and replace, the search string is :

\"[0-9][0-9][0-9][0-9][0-9][0-9]\"

This will find all the occurrences I need

However I'm unable construct the correct replace with reg ex to replace the match with itself followed by the @ sign e.g. "675605@

konsolebox · Accepted Answer · 2014-07-22 08:57:24Z

1

With sed you can have:

sed -r 's|"([0-9]{6})"|"\1@"|g' file

Add -i to modify it inline.

So my proposed regex - replacement form is:

"([0-9]{6})" - "\1@"

Quoted:

\"([0-9]{6})\" - \"\\1@\"

answered Jul 22, 2014 at 8:57

konsolebox

76.3k13 gold badges110 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Avinash Raj · Accepted Answer · 2014-07-22 08:57:38Z

1

Regex:

\"([0-9][0-9][0-9][0-9][0-9][0-9])\"

Replacement string:

"\1@

DEMO

Replacement string would be "\1" if you want "675605@"

answered Jul 22, 2014 at 8:57

Avinash Raj

175k32 gold badges247 silver badges289 bronze badges

Comments

AdamL · Accepted Answer · 2014-07-22 08:58:54Z

0

You need to use capturing groups. I don't know if you can use them in Edit Plus, but I think it should work:

Find what: \"(\d{6})\" Replace with: \"\1@\"

Where \1 is a number captured in parenthesis.

answered Jul 22, 2014 at 8:58

AdamL

13.3k5 gold badges57 silver badges79 bronze badges

Comments

Community · Accepted Answer · 2020-06-20 09:12:55Z

0

Open your file in vim or vi editor using below command:

vi "filename"

then use this command it replace your "675605" pattern with "675605@" :%s/675605/675605@/g then esc :wq now you open your file it replaced all your "675605" pattern with "675605@".

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Jul 22, 2014 at 9:07

Manjunath Goudar

112 bronze badges

Collectives™ on Stack Overflow

Replace string with modified string

4 Answers 4

Comments

Comments

Comments

vi "filename"

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

vi "filename"

Comments

Your Answer

Sign up or log in

Post as a guest

Related