January 18, 2012 at 11:14 am
I am trying to export the dataset returned from a stored procedure into a flat text file. One of the columns has a value as 5 CUM PRF ..
as you can see, the character is unprintible and is causing another dependent process to fail.
I am very new to this situation. Could someone please suggest?
Thanks for the help.
January 18, 2012 at 11:42 am
By unprintable characters, do you mean extended character set? Like Chinese "letters" and that kind of thing? Or do you mean ASCII instruction characters, like the tab-left character?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 23, 2012 at 2:52 pm
It's this box kind of character that one of our oracle linked servers contains in its table that we are pulling data from. I have no idea how would you categorize these characters but the oracle team calls it unprintable. It's the box type of character as i mentioned above.
January 25, 2012 at 2:53 am
johnnyk (1/23/2012)
It's this box kind of character that one of our oracle linked servers contains in its table that we are pulling data from. I have no idea how would you categorize these characters but the oracle team calls it unprintable. It's the box type of character as i mentioned above.
If you know the ASCII code of that character, you can issue REPLACE(myString,CHAR(x),'') to remove that character from the string.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply