replace carriage returns

[Kenneth Brody]

"Richard D. Williams" wrote:
> 
> When importing data from a mysql database, is there any way in filepro
> to find and replace a carriage-return in a field?
> 
> I can nont get the programmer I am dealing with to do it on his end.
> 
> All comments welcome as usual,

This will replace CRs with '~'s:

    result = xlate(field,chr("13"),"~")

Change the "~" to anything else, if desired.

-- 
+-------------------------+--------------------+-----------------------------+
| Kenneth J. Brody        | www.hvcomputer.com |                             |
| kenbrody at spamcop.net | www.fptech.com     | #include <std_disclaimer.h> |
+-------------------------+--------------------+-----------------------------+