Here is one for the true Guru's Please Help

General discussions about Advanced Find and Replace
Post Reply
jswenson
Posts: 2
Joined: Fri Mar 17, 2006 7:11 pm

Here is one for the true Guru's Please Help

Post by jswenson »

ok guys i need a lot of help I am new to this tool and do not even know
if this is possible but here is what i need:

i have 10,000 or more accounts in the exact arrangement below on a .txt document

555-555-5555,
john doe 555 john doe street
somecity, AL 36272 -1456

I NEED TO CONVERT THEM TO THIS

555-555-5555,john doe,555 john doe street,somecity,AL,36272,

note: deleting of -1456 (the last four digits of zip) a must for each account.

Help me please, this will take an eternity by hand

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

Post by Abacre »

Yes, it's possible with AFR.

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

Go to Batch replace tab, check on "Use regular expressions".
Put into the grid, search for:
(\d+-\d+-\d+),\s*\r\n(.*) (\d+ .*)\s*\r\n(.*),\s*(\w+)\s*(\d+)\s*-\d{4}

Replace with:
$1,$2,$3,$4,$5,$6

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

jswenson
Posts: 2
Joined: Fri Mar 17, 2006 7:11 pm

THANKS FOR THE HELP

Post by jswenson »

THANK YOU , it worked perfect. I will buy the program this week. Saved me a lot of tedious work.

Post Reply