Chr(127)

[matrixindicator]

Hey,

I do an import of a .dbf file. This is a neat file but a little contamination can occur.
I am familiar with Chr() use to replace some unwanted chararters. The case is, visually in my text I see a little square like in Chr(127) in the ANSI table. I tried Chr(129), Chr(157), Chr(144), Chr(143), Chr(141). But none of them recognize this sign and erase this. My code is tested with other signs that he recognize and repclace.

SANG
ESA

my second question is, when he dedect this sign how to say, replace with nothing, because the sign is in the word.

 

[RivetHed]

In my experience those squares are frequently carriage returns so you may want to try chr(13)

 

[matrixindicator]

I tried your suggestion, it should be yet something else.

 

[RivetHed]

Then you should probably check what value the unwanted character is with something like the Asc() function.

 

[PWise]

Asc(mid("SANG
ESA" ,5,1))

return 1

replace("SANG
ESA",chr(1),"")

returns SANGESA