Brent,
Try something like this:
cNewChar=" "
STRTRAN(string,Chr(0),cNewChar)
Regards,
Scott
>I have received a data file, exported from a Lotus Notes Table in tabular format. One field contains multiple values separated by what appears to be a null character. That is, it appears as a square box in common fonts and evaluates to zero in a ASC(SUBSTR(string,position,1)) function.
>I would like to find/replace, STRTRAN, STUFF, or other method to remove the offending character, but all methods known to me fail with this character.
>
>Help please.
>
>Brent
Scott King
The Support Source Corporation