DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 7 matches
Author Message
 Topic: Remove multiple special characters from leading and trailing
rahuljha26

Replies: 16
Views: 320

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 16, 2017 12:12 pm   Subject: Remove multiple special characters from leading and trailing
You need to look at the description of the function again. It takes all characters in the "from" list and replaces each with the corresponding (positional) character in the "to" list. In other words, ...
 Topic: Remove multiple special characters from leading and trailing
rahuljha26

Replies: 16
Views: 320

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 14, 2017 3:55 pm   Subject: Remove multiple special characters from leading and trailing
We don't know in which position we have which special characters.so multiple nested Trim() function also we can't use.
 Topic: Remove multiple special characters from leading and trailing
rahuljha26

Replies: 16
Views: 320

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 14, 2017 2:56 pm   Subject: Remove multiple special characters from leading and trailing
Thanks Srini...

yeah i did also the same thing and my output is also coming like the above output. i am wondering why it is not replacing the alphabet with 1.
 Topic: Remove multiple special characters from leading and trailing
rahuljha26

Replies: 16
Views: 320

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 14, 2017 12:30 pm   Subject: Remove multiple special characters from leading and trailing
Thanks Srini for ur reply...

No srini this is not delimeter &^.We don't have any delimeter in the input source. As i mentioned in the example that we will have input data like and we don't know ...
 Topic: Remove multiple special characters from leading and trailing
rahuljha26

Replies: 16
Views: 320

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 14, 2017 4:03 am   Subject: Remove multiple special characters from leading and trailing
Thanks qt_ky for replying the post .

can we have other method to do the above scenario. Instead of multiple nested Trim() function.
 Topic: Remove multiple special characters from leading and trailing
rahuljha26

Replies: 16
Views: 320

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 14, 2017 3:58 am   Subject: Remove multiple special characters from leading and trailing
Thanks craig for replying the post...

can you elaborate more how to find the first and last "non-special" character in the string using the Index function.
Any example will be helpful for this.
...
 Topic: Remove multiple special characters from leading and trailing
rahuljha26

Replies: 16
Views: 320

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Nov 11, 2017 11:32 am   Subject: Remove multiple special characters from leading and trailing
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Remove multiple special characters from leading and trailing of a string in datastage.

e.g.: Input Data like: !@##$$Rami^&Reddy*&^%$
Output Data Should: Rami^&Reddy

could yo ...
 

 Jump to:   



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