Page 1 of 1

Removing strange character: ഍

Posted: Wed Jan 05, 2011 8:25 pm
by Swiss1
I did try searching but could not find an answer here for this.

I need to be able to remove a strange character from the end of each line in several large text files. The character: ഍ (looks like a square just in case this does not display correctly here). This charater is at the end of each line. When I try to paste this into 'textPipe' is displays as a '?' (question mark).

Any ideas how I can easily remove this character?

Thanks in advance for your help.

Re: Removing strange character: ഍ update

Posted: Wed Jan 05, 2011 10:12 pm
by Swiss1
It looks like this might be a unicode character. If I copy just this character to notepad and save it as Unicode, it is preservered, but as ANSII, it becomes '?'. Unfortunately the file already contains this charachter, otherwise this would lead to a simple way to remove the unwanted character. Hex Code is: 0x0D0D I think.

Re: Removing strange character: ഍

Posted: Thu Jan 06, 2011 1:49 am
by Swiss1
Think I've solved the problem. The file format saved from MS-SQL is Unicode. I just have to open the file and save as ANSI and this looks like it solves the problem. Will know for sure in the morning when I check the latest file transfers.

Re: Removing strange character: ഍

Posted: Sun Jan 09, 2011 4:08 pm
by DataMystic Support
In TextPipe just use Filters\Wizards\Convert codepages and Unicode... to convert from Unicode to ANSI - saving this manual step.