notepad++ regex add character between two values

Question

I'm having a difficult time with regex expressions. I am trying to create a table for a wiki page.

I have:

{| class="wikitable" border="1"
|+ Printer connectivity troubleshooting
! Serial Number !! IP Address
|-
|G90001 192.168.10.21
|-
|G90002 192.168.10.22
|-
|G90069 192.168.10.19
|-

I need:

{| class="wikitable" border="1"
|+ Printer connectivity troubleshooting
! Serial Number !! IP Address
|-
|G90001 || 192.168.10.21
|-
|G90002 || 192.168.10.22
|-
|G90069 || 192.168.10.19

I was able to get the pipes at the beginning of the line in using find and replace and a macro, but I can't come up with a formula that works in the slightest for the pipes between the items. Thank you so much for the help.

Are there a lot of items? If it's only three it would probably be faster to just type it out — Explosion Pills
– Explosion Pills, Commented Dec 13, 2013 at 17:49

MDEV · Accepted Answer · 2013-12-13 17:49:50Z

2

(\|G9\d+) (.+)

To replace with

\1 || \2

Or a more generic match (not limiting to starting with G9)

^(\|\w+?) (.+)

answered Dec 13, 2013 at 17:49

MDEV

10.9k2 gold badges35 silver badges50 bronze badges

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

1 Comment

user3100329 Over a year ago

You're my hero! I knew I needed the separate expressions, but I couldn't get it work. I had a space between them, like you do and yours didn't work either just now, so that made me think about what could be wrong. I removed the space between the two and used your expression and it worked great! Thank you!!!!

Collectives™ on Stack Overflow

notepad++ regex add character between two values

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related