• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Special characters in the database field

 
Sangeetha Verkot
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I hope this is the right place to ask this question. I have SQL server (2000) database table that has encoded email messages. I want to decode this message and present it in plain English. But the problem is the database puts a special character in the end of each line that looks like a bold line. Does anyone know what this character is called and maybe how to replace it with ""? This is messing up my decoding method.

Thanks!
 
Chad Clites
Ranch Hand
Posts: 134
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I can think of a couple of approaches. Assuming that the message is just a string of some sort, it should be a matter (maybe) of figuring out what the symbol is and replacing all instances in a string. If you can capture the symbol using cut and paste or something, then it can be replaced in the string easily by using:
mystring.replace(character_to_replace,"");
That would be about the easiest approach I can think of.
 
Sangeetha Verkot
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks. I'll try to figure out a way to remove all the special characters from the body of the message.
 
Jan Cumps
Bartender
Posts: 2602
13
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sangeetha,

It might be an end-of-line character.
Wikipedia has a Newline entry.
Regards, Jan
[ June 14, 2007: Message edited by: Jan Cumps ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic