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