DataMystic

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.

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.

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.

In TextPipe just use Filters\Wizards\Convert codepages and Unicode... to convert from Unicode to ANSI - saving this manual step.