DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
gaelynalmeida



Group memberships:
Premium Members

Joined: 28 Jul 2017
Posts: 12

Points: 93

Post Posted: Tue Oct 31, 2017 6:08 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: U+0085, NEL
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.

http://www.dsxchange.com/viewtopic.php?p=464130
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42283
Location: Denver, CO
Points: 217108

Post Posted: Tue Oct 31, 2017 10:24 pm Reply with quote    Back to top    

What "code below"? If it's something from the linked topic, I'd suggest you include your actual code here instead.

_________________
-craig

Watch out where the huskies go and don't you eat that yellow snow
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54072
Location: Sydney, Australia
Points: 293282

Post Posted: Wed Nov 01, 2017 4:48 am Reply with quote    Back to top    

Try using either UniChar(133) or Char(133,1).

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42283
Location: Denver, CO
Points: 217108

Post Posted: Wed Nov 01, 2017 9:52 am Reply with quote    Back to top    

Ah yes, the magical ",1" secret sauce, forgot about that already. Wink

_________________
-craig

Watch out where the huskies go and don't you eat that yellow snow
Rate this response:  
Not yet rated
gaelynalmeida



Group memberships:
Premium Members

Joined: 28 Jul 2017
Posts: 12

Points: 93

Post Posted: Wed Nov 01, 2017 2:24 pm Reply with quote    Back to top    

chulett wrote:
What "code below"? If it's something from the linked topic, I'd suggest you include your actual code here instead.


Hi Craig .. thank you for responding. I meant the "link below"

http://www.dsxchange.com/viewtopic.php?p=464130

I will try the uchar suggestion and update this post with the outcome
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42283
Location: Denver, CO
Points: 217108

Post Posted: Wed Nov 01, 2017 3:47 pm Reply with quote    Back to top    

Figured, hence my comment. If you do end up needing help with this, best to post your own code here so we can see what you're actually dealing with.

_________________
-craig

Watch out where the huskies go and don't you eat that yellow snow
Rate this response:  
Not yet rated
gaelynalmeida



Group memberships:
Premium Members

Joined: 28 Jul 2017
Posts: 12

Points: 93

Post Posted: Wed Nov 01, 2017 5:53 pm Reply with quote    Back to top    

Smile

how do I post code? I don't see an option to attach a dsx file, or for adding screenshots. I can upload a sample job with sample input and output files.
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42283
Location: Denver, CO
Points: 217108

Post Posted: Wed Nov 01, 2017 9:25 pm Reply with quote    Back to top    

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] 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

Watch out where the huskies go and don't you eat that yellow snow
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54072
Location: Sydney, Australia
Points: 293282

Post Posted: Thu Nov 02, 2017 12:08 am Reply with quote    Back to top    

gaelynalmeida wrote:
I will try the uchar suggestion and update this post with the outcome

UniChar() function, not UChar() function.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
gaelynalmeida



Group memberships:
Premium Members

Joined: 28 Jul 2017
Posts: 12

Points: 93

Post Posted: Tue Nov 14, 2017 9:48 pm Reply with quote    Back to top    

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?
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42283
Location: Denver, CO
Points: 217108

Post Posted: Wed Nov 15, 2017 8:11 am Reply with quote    Back to top    

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?

_________________
-craig

Watch out where the huskies go and don't you eat that yellow snow
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54072
Location: Sydney, Australia
Points: 293282

Post Posted: Wed Nov 15, 2017 6:13 pm Reply with quote    Back to top    

UniChar() and UniSeq() functions are only available if NLS is enabled.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
gaelynalmeida



Group memberships:
Premium Members

Joined: 28 Jul 2017
Posts: 12

Points: 93

Post Posted: Tue Dec 05, 2017 6:36 pm Reply with quote    Back to top    

OK .. thank you for responding.

Does it need to be enabled at the project or the job level?

If project, then I will check with the admins to see whether this is enabled.
I tried researching ways to figure this out myself, but did not find any information.

Thank you
Rate this response:  
Not yet rated
gaelynalmeida



Group memberships:
Premium Members

Joined: 28 Jul 2017
Posts: 12

Points: 93

Post Posted: Tue Dec 05, 2017 6:37 pm Reply with quote    Back to top    

chulett 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?


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 function
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours