01-11-2010 03:10 PM
01-11-2010 04:57 PM
03-09-2016 01:54 PM - edited 03-09-2016 02:35 PM
similar problem with data imported from Access.
FORMAT fname $HEX20.;
I get this: 20444F55474C41532020
20 is ascii for a space.
but TRIM(fname) does not remove the leading space.
ANYALPHA(fname) still returns 2.
03-09-2016 04:48 PM
Thanks. The joys of regularly programming in 4 different langauges.
Returns a string that contains a copy of a specified string
without leading spaces (LTrim),
without trailing spaces (RTrim), or
without leading or trailing spaces (Trim).
Removes trailing blanks from a character string, and returns one blank if the string is missing.
is one of the following:
removes the blanks or specified characters from the beginning of the character string.
removes the blanks or specified characters from the end of the character string.
removes the blanks or specified characters from both the beginning and the end of the character string.