how to get the result in Transformer particular letters

deesh · Post by **deesh** » Sat Dec 01, 2012 2:58 am

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.

ArndW · Post by **ArndW** » Sat Dec 01, 2012 4:01 am

The transformation

Convert('0123456789','',In.INPUT)

should do the trick of removing all numeric characters from the string, if that was your intent.

ray.wurlod · Post by **ray.wurlod** » Sat Dec 01, 2012 4:40 am

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)

ArndW · Post by **ArndW** » Sat Dec 01, 2012 5:14 am

Thanks Ray, I only looked at the first line and thought that the OP wanted only to remove numbers from a string; upon re-reading I saw that what I posted was incomplete. I like your solution, I don't recall having seen that before - it is elegant and simple and quick.

chulett · Post by **chulett** » Sat Dec 01, 2012 8:37 am

It popped up here a number of years ago, don't recall who first posted it but some searching might turn it up. And I remember thinking that as a technique it was quite... cool.