How can I remove numeric values from a string?

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

Post Reply
balaya.ds
Participant
Posts: 27
Joined: Fri Dec 25, 2009 10:50 pm

How can I remove numeric values from a string?

Post by balaya.ds »

the string is like in the source data
" abcde 1234 efgh 45678 nmhj 7895 ". i
In parallel jobs I want to convert in target like "abcde efgh " ie i want to remove numeric values and send string to target
Last edited by balaya.ds on Sun Jan 17, 2010 12:29 am, edited 1 time in total.
Sudheer
DS_SUPPORT
Premium Member
Premium Member
Posts: 232
Joined: Fri Aug 04, 2006 1:20 am
Location: Bangalore

Post by DS_SUPPORT »

Welcome to Dsxchange.

You have posted the question in wrong forum, Please post it in correct forum to get appropriate answers.
gssr
Participant
Posts: 243
Joined: Fri Jan 09, 2009 12:51 am
Location: India

Post by gssr »

In which Version 7x or 8x?
parallel Or Server?
Post in the right forum, so that everyone can understand your requirement.

For Px, you can use functions with Transformer stage.
Go through the online manual of Parjdev to know more about the functions.
RAJ
nikhilanshuman
Participant
Posts: 58
Joined: Tue Nov 17, 2009 3:38 am

Re: This is a string given below..

Post by nikhilanshuman »

balaya.ds wrote:the string is like in the source data
" abcde 1234 efgh 45678 nmhj 7895 ".
i want to convert in target like "abcde efgh " ie remove numeric values
Use the Convert function in the transformer to convert the numbers.
Syntax : Convert(%fromlist%,%tolist%,%expression%)
For example to remove the number try:
convert('123456789',' ',"InputLinkName.ColumnName")
Nikhil
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

This forum is not for this kind of question. This forum is to discuss topics about which a more formal FAQ might appear in the FAQ forum.

Topic relocated per request - Andy

Everyone else: please don't answer until the question is in the correct forum.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply