help

Lets assume that if number is inside <>

make sure that dattype is not converted before

- Convert this column to Text

- Replace "," comma with nothing

- Replace "<" with nothing

- Replace ">" with nothing

- Convert the data type to Decimal.

Hi sameergupta60 ,

You may select on this column, then go to Transform ->Extract ->Text Between Delimiters, set like below.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.