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,
Roger

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 used the example code I listed above in the "Trial input" box ...

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 ...