replace text using regular Expression in Notepad++

Question

I have following text as input.

1 "India"  1 "IN" 
2 "Germany" 2 "GM" 
3 "Canada"  3 "CN" 
4 "United States"  4 "US"

and I want to convert all this strings to following pattern

<value in="India" out="IN"/> 
<value in="Germany" out="GM"/> 
<value in="Canada" out="CN"/> 
<value in="United States" out="US"/>

How to do it using regular expression? I am using notepad++

This is a simple task for regular expressions. Show what you have already tried and explain why it does not do what you want. — AdrianHHH
– AdrianHHH, Commented Apr 23, 2014 at 12:06

hwnd · Accepted Answer · 2014-04-23 12:17:48Z

2

Make sure you place the cursor at the beginning of the file.

Hit CTRL+H.
Choose the Replace tab.

Select Regular Expression at the bottom.

Find: \d+\s+"(.*?)".*?"(.*?)"  
Replace: <value in="\1" out="\2"/>

edited Apr 23, 2014 at 12:17

hwnd

70.9k4 gold badges100 silver badges135 bronze badges

answered Apr 23, 2014 at 12:10

Pedro Lobito

99.8k36 gold badges274 silver badges278 bronze badges

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

Comments

aelor · Accepted Answer · 2014-04-23 12:21:38Z

0

find : ^.*?"([^"]+)"[^"]+"(\w+)"

replace with : <value in="\1" out="\2"/>

output :

<value in="India" out="IN"/> 
<value in="Germany" out="GM"/> 
<value in="Canada" out="CN"/> 
<value in="United States" out="US"/>

demo here : http://regex101.com/r/hH3rZ4

answered Apr 23, 2014 at 12:21

aelor

11.2k3 gold badges35 silver badges48 bronze badges

Comments

Russell Zahniser · Accepted Answer · 2014-04-23 12:10:48Z

0

I don't have Notepad++, but in SubEthaEdit, I would do this:

Find:

[^"]*("[^"]*")[^"]*("[^"]*")[^"]*

(five sections of "not a quote", separated by quotes, capturing the two quoted parts)

Replace:

<value in=\1 out=\2/>\n

This ought to be very similar in Notepad++.

answered Apr 23, 2014 at 12:10

Russell Zahniser

16.4k41 silver badges31 bronze badges

Collectives™ on Stack Overflow

replace text using regular Expression in Notepad++

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related