I have a situvation where i need to drop the string present in the source coloum and load only the numeric values at the target
Source Target
abc100 100
a1000 1000
abcd10 10
Can any one help me out what appropriate function in transformet need to be used or without using transformer can we devlop a job.
Thanks
siri
Transformer
Moderators: chulett, rschirm, roy
If your input is file then use sed command in sequential file filter
Or
If you have only alphabets then use Convert function
Or
If you have alphabets and other characters
Code: Select all
sed "s/[^0-9]//g" file
If you have only alphabets then use Convert function
Code: Select all
Convert("abcd...zABC...Z","",Field)
If you have alphabets and other characters
Code: Select all
svTmp=Convert("0123456789","",Field)
svNum=Convert(svTmp,"",Field)
You are the creator of your destiny - Swami Vivekananda
anbu wrote:If your input is file then use sed command in sequential file filterOrCode: Select all
sed "s/[^0-9]//g" file
If you have only alphabets then use Convert functionOrCode: Select all
Convert("abcd...zABC...Z","",Field)
If you have alphabets and other charactersCode: Select all
svTmp=Convert("0123456789","",Field) svNum=Convert(svTmp,"",Field)
Hi,
Thanks for the immediate reply iam very clear with your first option i.e filter command supposed to use in the sequential file
How do i use the rest of the two functions,are these the functions in transformer
Thanks in advance
siri.
Code: Select all
Convert(Convert("0123456789 ","",yourString), "", yourString)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers