Hi,
The square box symbol can represent any non-printable character, the vertical bar will code may depend on local settings. To find out which they are try something like:
FOR i = 1 TO LEN(fieldname)
ch = SUBSTR(x,i,1)
? ASC(ch),ch
ENDFOR
To get rid of them:
REPL ALL fieldname WITH CHRTRAN(fieldname,CHR(n)[+CHR(n)..],"")
HTH,
Viv
>I am seeing a few either boxes or dark vertical bars amidst data in a dbf file. I think these are some control character that has been inserted into the file. The file is imported from some mapping software. Is there a way to search for this character? The ASC(FIELD) of this returns 0. I can export to a .txt file and the field appears as a box. I could do the search here also if I knew what the character was. I'd just like to search and remove all of these characters.
>
>thanks
>
>bonnie