Special Character - ^Ã–

chulett · Post by **chulett** » Tue Jan 05, 2010 10:42 am

Is that actually one character? You need to find the hex/decimal value of it in order to remove it. From UNIX you can try either an "od -h" to dump it in hex or use an actual hex editor to determine that. Lots of free ones out there.

arun_im4u · Post by **arun_im4u** » Tue Jan 05, 2010 10:49 am

Yes. It is actually one charater. Let me do some research on the od -h.

Thanks

chulett · Post by **chulett** » Tue Jan 05, 2010 10:57 am

Once you do find the decimal value, you can use the CHAR() function to represent it and then include that in something like Convert() to remove it by converting it to '', an empty string.

arun_im4u · Post by **arun_im4u** » Wed Jan 06, 2010 10:28 am

I did od -c on the file and found the corresponding ascii value (226). I used the convert function with char(226) but it still does not remove it.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 06, 2010 3:46 pm

Is NLS enabled? This byte may be a leading byte in a multi-byte character.