>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,
I don't understand how you can create a fixed field length file fomr varible field lentgh daat, but the function you want is StrTran().
REPLACE MemoField WITH STRTRAN(MemoField,CHR(13),CHR(253))