regular expression help

dabombst · Post by **dabombst** » Mon Mar 27, 2006 6:30 pm

Hi

I need to delete from the "\" to the ";", but dont want the semicolon to be delete.

Export002\AIG 005647-AIG 005647;AIG 005647-AIG 005647.T
Export00200\AIG 005648-AIG 005648;AIG 005648-AIG 005648.T
Export0022\AIG 005649-AIG 005649;AIG 005649-AIG 005649.T

to look like this...

Export002;AIG 005647-AIG 005647.T
Export00200;AIG 005648-AIG 005648.T
Export0022;AIG 005649-AIG 005649.T

thanks

SteveH · Post by **SteveH** » Mon Mar 27, 2006 6:59 pm

You need to use the following regular expression:

Find:

\\.*;

Replace with:

;

This finds instances of \ (the initial \ escape character makes this a literal backslash) followed by any character (.) repeated (*) and followed by a ;. This string is replaced with a ;

dabombst · Post by **dabombst** » Mon Mar 27, 2006 10:47 pm

thanks

Niels H. Veldhuijzen · Mon Aug 21, 2006 12:51 pm

Dear SteveH,

Are you sure this will work when there are two or more semicolons in one line? :(

ben_josephs · Post by **ben_josephs** » Mon Aug 21, 2006 1:00 pm

If you want to delete from the first '\' to the first ';' following, use:

Find what: \\[^;]*;
Replace with: ;

[X] Regular expression