>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
First of all, you may want to use a hex editor (like the one included with Visual FoxPro) to see the file at a "low level".
StrTran() seems appropriate to me.
Once you find the actual value of the character, you may try some combination of: at(), string concatenation (+), stuff(), and perhaps a few others more.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)