Removing strange character: ഍

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Swiss1
Posts: 3
Joined: Wed Jan 05, 2011 8:04 pm

Removing strange character: ഍

Postby Swiss1 » Wed Jan 05, 2011 8:25 pm

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.

Swiss1
Posts: 3
Joined: Wed Jan 05, 2011 8:04 pm

Re: Removing strange character: ഍ update

Postby Swiss1 » Wed Jan 05, 2011 10:12 pm

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.

Swiss1
Posts: 3
Joined: Wed Jan 05, 2011 8:04 pm

Re: Removing strange character: ഍

Postby Swiss1 » Thu Jan 06, 2011 1:49 am

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.

User avatar
DataMystic Support
Site Admin
Posts: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Removing strange character: ഍

Postby DataMystic Support » Sun Jan 09, 2011 4:08 pm

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

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Yahoo [Bot] and 1 guest