Community

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

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 ;

thanks

Dear SteveH,

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

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

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

[X] Regular expression