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



Joined: 16 Mar 2006
Posts: 325

Points: 2457

Post Posted: Thu Sep 06, 2018 7:56 am Reply with quote Back to top

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hello,

I am using the convert function to replace special character with English one.

Convert("","AAAAAAECEEEEIIIIDNOOOOOx0UUUUYPsaaaaaaeceeeeiiiiOnooooo/0uuuuypy", input_column)

Problem is input column contains '' and I am expecting an 'e' but I am getting a 'A' instead

Is it possible the convert function can not handle certain character correctly ? I tried to use convert function just with this character but still not working.

Ereplace is not better when using for this specific character ''

Thanks for your help
chulett

Premium Poster


since January 2006

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

Joined: 12 Nov 2002
Posts: 42764
Location: Denver, CO
Points: 220364

Post Posted: Thu Sep 06, 2018 10:12 am Reply with quote Back to top

You may need to investigate the use of the CHAR() function to represent that character...

_________________
-craig

Research shows that 6 out of 7 dwarves aren't happy
Rate this response:  
Not yet rated
Sumith
Participant



Joined: 04 Sep 2018
Posts: 5

Points: 31

Post Posted: Thu Sep 06, 2018 2:55 pm Reply with quote Back to top

Have you done NLS setting in the job level or project level to read Unicode characters. Also, in the column datatype, please specify Unicode and try.

_________________
Thanks
Sumith
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: 54398
Location: Sydney, Australia
Points: 295054

Post Posted: Thu Sep 06, 2018 5:40 pm Reply with quote Back to top

How did you get the characters in the first argument into the routine editor? Copy/paste can give problems, as there are non-printing characters that Microsoft Office products insert to control the a ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne (especially seeking good business analysts)
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