Hi,
My file input is like
INPUT OUTPUT
1A3D5G ADG
A2DG57 ADG
&$A#DG ADG
(*AD&G ADG
hot to get the output like that.
how to get the result in Transformer particular letters
Moderators: chulett, rschirm, roy
how to get the result in Transformer particular letters
Last edited by deesh on Sat Dec 01, 2012 4:27 am, edited 1 time in total.
The transformation should do the trick of removing all numeric characters from the string, if that was your intent.
Code: Select all
Convert('0123456789','',In.INPUT)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Use the "double convert" trick to remove all non-alphabetic characters from the string. This has been discussed many times on DSXchange. In your particular case (keep only alphabetic characters) the expression is:
Code: Select all
Convert(Convert("ABCDEFGHIJKLMNOPQRSTUVWXYZ", "", InLink.TheString), "", InLink.TheString)
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.