Replace in file with 10 000 lines

General discussions about Advanced Find and Replace
Post Reply
zootycoonvn
Posts: 13
Joined: Mon Aug 20, 2007 9:25 am

Replace in file with 10 000 lines

Post by zootycoonvn »

I have 1 file txt have 10 000 line.
Such as :
125---Deborah---Walker---KOKO---103 Ashmore Drive
127---Dennis---Heymans---------KOKO---------226 Maryland
128---Sidney---Meyers---------Tomato---Sugare---------5015 St. Croix Ave
129---Kim---Crump---------KOKO---------231 Lakeview
130---lori---curreri---------Meal---Salt---------27 darwin road

Sult :
CANT---125---Deborah---Walker---KOKO---103 Ashmore Drive
CANT---127---Dennis---Heymans---------KOKO---------226 Maryland
128---Sidney---Meyers---------Tomato---Sugare---------5015 St. Croix Ave
CANT---129---Kim---Crump---------KOKO---------231 Lakeview
130---lori---curreri---------Meal---Salt---------27 darwin road

Or Sult :
KOKO---103 Ashmore Drive
KOKO---------226 Maryland
128---Sidney---Meyers---------Tomato---Sugare---------5015 St. Croix Ave
KOKO---------231 Lakeview
130---lori---curreri---------Meal---Salt---------27 darwin road

Plzz help me.
Thanks.

Abacre
Site Admin
Posts: 1223
Joined: Mon Jan 31, 2005 5:32 pm

Re: Replace in file with 10 000 lines

Post by Abacre »

For the first solution you should use the following:

Go to main menu - Action - Options - Batch Replace
check "Modifier M"
uncheck "Modifier S"
uncheck "Modifier G"

Go to Batch replace tab, check on "Use regular expressions".
Put into the grid, search for:
^(.*-KOKO)

Replace with:
CANT---$1

That's all I verified it works perfectly.
Kind regards,
Abacre Limited
http://www.abacre.com
support@abacre.com

zootycoonvn
Posts: 13
Joined: Mon Aug 20, 2007 9:25 am

Re: Replace in file with 10 000 lines

Post by zootycoonvn »

Thanks very much.

Post Reply