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
How can I remove numeric values from a string?
Moderators: chulett, rschirm, roy
How can I remove numeric values from a string?
Last edited by balaya.ds on Sun Jan 17, 2010 12:29 am, edited 1 time in total.
Sudheer
-
- Premium Member
- Posts: 232
- Joined: Fri Aug 04, 2006 1:20 am
- Location: Bangalore
-
- Participant
- Posts: 58
- Joined: Tue Nov 17, 2009 3:38 am
Re: This is a string given below..
Use the Convert function in the transformer to convert the numbers.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
Syntax : Convert(%fromlist%,%tolist%,%expression%)
For example to remove the number try:
convert('123456789',' ',"InputLinkName.ColumnName")
Nikhil
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.