DataMystic

Thank you Simon! It worked!

(\d+.*)(,)([\w\.\ ]+.* to )([\w\.\ ]+.*)( for )([\d]*\$\d+?)

Thanks again!

Roger

(\w+.*to) This is the problem spot as it is looking for any "word" character with the usage of \w and there are periods (.) in this section such as: Ronald J. Prater and Gary M. and Margaret Boswell to I've tried a few things, but nothing seems to help me get around this. Ideas? Thanks, Ro...

Wow! Thanks Simon for the prompt reply. Here's what I did... 1. I copied your code verbatim into the "Find pattern (perl-style)" box. 2. Put "$6","$4","$1" into the "Replace with" box. 3. No check marks below the "Replace with" box. 4. I us...

I'm making this much harder than it should be... I have one file, with multiple lines such as: 2800 Western Parkway, Ronald J. Prater and Gary M. and Margaret Boswell to Hugh P. and Jennifer Bosley for $118,000. 423 Tampa Drive, Kevin D. and Tabitha Hooker to Angela Baird for $67,000. 5035 Graham La...