Invalid Characters

[benjatado]

I am trying to weed out invalid characters from my data. I am having problems with characters that look like a square, I thought I could do something like an RTRIM() to eliminate them, but this did not work...??

Does anyone know what the "square" looking character represents? And how to eliminate them from the values?

Thanks!!

 

[DotNetGnat]

square looking characters are tab characters...

i think you need to use something like

Replace(yourfield,chr(13),"")

-DNG

 

[checkai]

yeah, i'd play around with finding char(10)'s and char(13)'s...

"...we both know I'm training to become a cagefighter...see what happens if you try 'n hit me..."