Regular expression for Notepad++

Question

Long story short, I have a very large table (1200+ rows) from a custom Excel to html conversion, which is working beautifully, except for a final missing part. I'm no good with RegEx, and I think I need it for a Find and Replace in Notepad++. Below is what I have and what I need.

Input:

<td>image1</td>
<td>image2</td>
...
<td>image1242</td>

Needed output:

<td><img src="image1.png" alt="" /></td>
<td><img src="image2.png" alt="" /></td>
...
<td><img src="image1242.png" alt="" /></td>

Please advice!

score 2 · Answer 1 · edited May 23 '17 at 12:33

2

Use this regular expression:

<td>image(.+)</td>

and the following pattern as a replacement:

<td><img src="image\1.png" alt"" /></td>

As a sidenote, it is usually not a good practice to parse HTML with regular expressions - in simple cases like this, it might be sufficient, but for anything more complicated, it would be much better to parse the HTML like XML file.

If you know some C#, you could use HTML Agility Pack for that.

edited May 23 '17 at 12:33

Community

1
1

answered Sep 01 '12 at 12:07

Nikola Anusev

6,940
1
30
46

@user1640453 I've edited the expression to accommodate for that - if there can be only numbers after the 'image', you could use `image([0-9]+)` as the expression to make it a bit safer. – Nikola Anusev Sep 01 '12 at 12:14
Almost there, but missing the png extension – user1640453 Sep 01 '12 at 12:19
Awesome, you nailed it! Much obliged. – user1640453 Sep 01 '12 at 12:22

score 1 · Answer 2 · answered Sep 01 '12 at 12:17

1

Do this way:-

Find What:

<td>image(\d+)</td>

Replace With:

<td><img src="image\1.png" alt="" /></td>

Refer the screenshot:

Find Replace with Regex

answered Sep 01 '12 at 12:17

Siva Charan

17,940
9
60
95

Regular expression for Notepad++

2 Answers2

Find What:

Replace With: