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
Here is one for the true Guru's Please Help
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.
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.
THANKS FOR THE HELP
THANK YOU , it worked perfect. I will buy the program this week. Saved me a lot of tedious work.