Finding Ampersands

[John Chamberlain]

I am trying to clean up a file in which certain fields contain an ampersand (&). These records need to be split into two different records. A simple find on a special character does not work. Can anyone tell me how to do this?

TIA

[LaRetta]

Hi John,

You need to enter it as literal text, so to find you would enter "&"

LaRetta

[LaRetta]

Hi John,

I thought you might also want input on splitting the records. Be sure to back up first. The following script is an idea to work with. I don

[John Chamberlain]

Hi LaRetta -

Of course - for some dumb reason I was trying to find ="&" - doh!

I appreciate your effort on the duplication script, but there are only 36 records like this so I will probably just duplicate them and then split the name fields.

Thanks,