DataStage remove NEL from data
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 12
- Joined: Fri Jul 28, 2017 1:01 pm
DataStage remove NEL from data
Hi all,
I am trying to remove the NEL character (Next Line - U+0085) from an input data set. I have successfully implemented the code below to remove other non-printable etc. characters from my input data. However, this does not address NEL, which remains on the output file.
Does anyone know how to do this?
I tried adding CHAR(133) to the convert string, but that does not work.
viewtopic.php?p=464130
I am trying to remove the NEL character (Next Line - U+0085) from an input data set. I have successfully implemented the code below to remove other non-printable etc. characters from my input data. However, this does not address NEL, which remains on the output file.
Does anyone know how to do this?
I tried adding CHAR(133) to the convert string, but that does not work.
viewtopic.php?p=464130
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 12
- Joined: Fri Jul 28, 2017 1:01 pm
Hi Craig .. thank you for responding. I meant the "link below"chulett wrote:What "code below"? If it's something from the linked topic, I'd suggest you include your actual code here instead.
viewtopic.php?p=464130
I will try the uchar suggestion and update this post with the outcome
-
- Premium Member
- Posts: 12
- Joined: Fri Jul 28, 2017 1:01 pm
There's no need to do anything dsx related. Screenshots work like most other boards, you upload them to a file sharing service and then use [img] tags to embed a link to them in a post. However, all we're asking for is a simple copy/paste of the derivations. You can also wrap them in
Code: Select all
[/b] tags to preserve any formatting or whitespace involved, otherwise the forum software will strip it all out. They are the green pieces of text you've probably seen in other posts.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 12
- Joined: Fri Jul 28, 2017 1:01 pm
error with UniChar
I get an error when I try to use the UniChar function in the transformer. Is there some additional component that I need to install?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 12
- Joined: Fri Jul 28, 2017 1:01 pm
-
- Premium Member
- Posts: 12
- Joined: Fri Jul 28, 2017 1:01 pm
I get the error when editing the design in the transformer stage - i.e. the transformation is "red", which in this case, means it does not recognize the functionchulett wrote:Can you be more specific, please? Post the error and let us know when you get it - editing the design, when you compile it, at runtime?