How to remove alphanumeric characters using transformer?

Prince_Hyd · Post by **Prince_Hyd** » Thu Jul 25, 2013 12:15 am

Hi Folks

i have a source like this

ID
122133@324
$324234423
$324342346

i want to remove those alphanumeric characters,how can i achieve it.

Thanks

ray.wurlod · Post by **ray.wurlod** » Thu Jul 25, 2013 12:25 am

Let's be clear about what you mean by "alphanumeric".

In the industry this term is commonly understood to include alphabetic characters (letters) and numeric characters (digits).

I suspect that's not what you mean in this case.

A generic solution to preserve alphanumeric characters (as conventionally understood) uses the "double convert" technique discussed earlier.

Code: Select all

Convert(Convert("ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789", "", UpCase(InLink.TheString)), "", InLink.TheString)

which is what I suspect you desire.

To remove alphanumeric characters just use the inner Convert() function.

Code: Select all

Convert("ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789", "", UpCase(InLink.TheString))

In your example the result would be:

ID
@
$
$

Prince_Hyd · Post by **Prince_Hyd** » Thu Jul 25, 2013 12:41 am

hey ray

sorry for that i dint noticed that properly i want to remove those symbols like @,$

ray.wurlod · Post by **ray.wurlod** » Thu Jul 25, 2013 2:25 am

Then use the first of the solutions that I offered.

crystal_pup · Post by **crystal_pup** » Thu Jul 25, 2013 6:30 am

Use the convert function