Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett, rschirm, roy
-
chulett
- Charter Member
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
A combination of the Convert() and CHAR() functions should do the trick, me thinks.
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
You need to know what codepoint em dash uses.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
chulett
- Charter Member
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
I'm assuming they already know this since they are successfully doing what is essentially the same thing in Oracle.
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
goriparthi
- Charter Member
- Posts: 57
- Joined: Fri Feb 24, 2006 7:44 am
Post
by goriparthi »
Try This
TrimF(Convert(char(0):char(9):char(10):char(13),'-', ColumnName))
-
krisna
- Participant
- Posts: 77
- Joined: Tue Apr 08, 2008 11:33 pm
Post
by krisna »
Thanks everyone for the answers. How do i remove all unprintable characters before writing to a file.
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
By keeping only printable characters.
But is this really what you want to do? Some of these non-printing characters may be part of your client's valid data.
If you insist, use the "double Convert()" technique.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
krisna
- Participant
- Posts: 77
- Joined: Tue Apr 08, 2008 11:33 pm
Post
by krisna »
Used regexp_replace oracle function in source query to avoid unprintable characters.