I have to use the decimal stripe logic in my job in tmap

[smore1665386696]

Basically have to replace trtt00376.625gajsH = 0376.625​ using regular expression . Please help me with this

I tried forming one equation but it's showing me incorrect character error.

Regexp_replace ('column_name','[^-0-9.],' ');​

[dilip_n]

HI there,

I thinks this one will be helpful

StringHandling.CHANGE("trtt00376.625gajsH","[a-zA-Z]","")

or

StringHandling.EREPLACE("trtt00376.625gajsH","[^-0-9.]","")

better use [a-zA-Z] to replace with with "no space" like as shown in above function.

both the conditions are working... Still you are not getting output? ping me with column type that you are using.

[smore1665386696]

The column type​ is bid decimal.

[smore1665386696]

Output i am getting for above expression is

1 ._

Where expected output should be 0376.625​

[dilip_n]

in this case read entire file as string then use tmap after that convert into bigdecimal to output

[dilip_n]

other wise we need to use tjavarow to resolve it

[smore1665386696]

How can be done? Data type is bigdecimal for that column .​