>Can someone tell me how to search through a memo field to find any occurrences of CHR(13) and then replace it with another value, say CHR(253)? I'm trying to export the contents of a DBF which contains memo fields to a fixed length SDF file. Since many of the records contain hard returns in the memo field, exporting to an SDF file actually creates multiple records after each hard return.
>
>Thanks in advance!
>
>Patrick Kirkman
You can scan through records and
Replace memofield with chrtran(memofield,chr(13),chr(253))
Edward Pikman
Independent Consultant