Page 1 of 1
How can I remove numeric values from a string?
Posted: Sun Dec 27, 2009 10:42 pm
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
Posted: Sun Dec 27, 2009 11:21 pm
by DS_SUPPORT
Welcome to Dsxchange.
You have posted the question in wrong forum, Please post it in correct forum to get appropriate answers.
Posted: Mon Dec 28, 2009 1:03 am
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.
Re: This is a string given below..
Posted: Mon Dec 28, 2009 4:14 am
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")
Posted: Tue Dec 29, 2009 4:26 am
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.