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 » Mon Aug 20, 2007 9:36 am

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: 1198
Joined: Mon Jan 31, 2005 5:32 pm
Contact:

Re: Replace in file with 10 000 lines

Post by Abacre » Mon Aug 20, 2007 11:22 am

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 » Tue Aug 21, 2007 6:23 am

Thanks very much.

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests