Remove extra charters from column

[Anonymous]

Hi All,

How i can remove the extra string/caracter from column using tmap.

Need to remove till 00:00:00  if exist  else ignore.

Colum1

28SEP 00:00:00 120

33

20DEC 00:00:00 24

Expected output.

colum1

120
33

24

Thanks

Shree

[Anonymous]

Hi @TRF,

Thanks you so much, its working as expected.

Regards

Shree