Need some help with this Find/Replace please...???

[angelleye]

A bunch of records got updated with false data that needs removed. The data is an address and is kept in a notes field. The data was inserted with an external script via ODBC and uses chr(13) for cairrage returns to format the address:

Name

Street 1

City, ST 00000

(000)555-3432

I simply need to remove this. Is a Find/Replace the best way to do this? And if so, can I use chr(13) within that the same way I did in the script that inserts the data? So my Find would be

Namechr(13)Street 1chr(13)City, ST 00000chr(13)(000)555-3432

Replace would be blank. Will that work?

[angelleye]

Nevermind, I"m sorry. I overlooked the Tip in the FM help the first time I looked.

[Keith LaMarre]

First - back up the file as is - then can create use the "Substitite" function to replace "chr(13)" with "¶"

Substitute ( table:fieldname ; "chr(13)";"¶")

this will probably add an extra carriage return at the end but you can get rid of that later.