[RESOLVED] Reg Ex in TextPad

[FishGuy]

Hi,

Using TextPad can I use Reg Ex Find and Replace somehow to change a file formatted like

7000 Sean Lockley Canvass
6700 Caren Larkman Canvass
4200 Toyon St-Hiliare Canvass
2200 Nick Metcalfe Canvass
1200 Adam Conway Canvass
73949 Richard Harker Inbound
70425 Mark Butler Inbound

To look like

6700|"Sean Lockley"|"Canvass"
5150|"Adam Conway"|"Canvass"
76331|"Richard Harker"|"Inbound"
59745|"Mark Butler"|"Inbound"
50940|"Stephen Riddiough"|"Inbound"
32695|"Neil Moore"|"Inbound"

If not whats the best way?

I have 34 files like this to change.

[DeadEyes]

you could try this two step process
1. Find: (\s*\t|\t) Replace: "|"
2. Find: (\d)" Replace: $1
That's assuming that the replace allows subexpressions
If it doesn't see does it support lookbehinds (?<=\d)" and replace with blank