String Handling in tMap

[vamsi99]

Hi,

I have a column row5.Example and the values will be like

CN=HYAHCU YXCUKSRM,OU=20992021,OU=Employees,O=CM,DC=avrhcjk,DC=otn,DC=com. How will I get only numeric value that is 20992021

as result/output by using tMap or any other way.

Note : In this scenario we hare 20k records and all the records are similar.

[gjeremy1617088143]

If its the only numeric in the string :

Set this in the tmap output row :

row5.Example.replaceAll("\\D","")

it will suppress all non digit char from the string

Send me Love and Kudos