Transformer

[sirishds]

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

[peddidsx]

Is there a scenario where the letters fall in between the numbers?

[sirishds]

Is there a scenario where the letters fall in between the numbers?

No numeric followed by string.

[anbu]

If your input is file then use sed command in sequential file filter

Code: Select all

sed "s/[^0-9]//g" file

Or

If you have only alphabets then use Convert function

Code: Select all

Convert("abcd...zABC...Z","",Field)

Or

If you have alphabets and other characters

Code: Select all

svTmp=Convert("0123456789","",Field)
svNum=Convert(svTmp,"",Field)

[sirishds]

If your input is file then use sed command in sequential file filter

Code: Select all

sed "s/[^0-9]//g" file

Or

If you have only alphabets then use Convert function

Code: Select all

Convert("abcd...zABC...Z","",Field)

Or

If you have alphabets and other characters

Code: 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.

[anbu]

Yes Convert function is for transformer

[chulett]

Code: Select all

Convert(Convert("0123456789 ","",yourString), "", yourString)