Forum Discussion

sameergupta60's avatar
sameergupta60
Helper IV
6 years ago
Solved

help

0,<3.519307092255493E+09>, can convert in decmial format
Need Help
  • FarhanAhmed's avatar
    FarhanAhmed
    6 years ago

    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.

     

  • v-xicai's avatar
    v-xicai
    6 years ago

    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.

amitchandak's avatar
amitchandak
Super User
6 years ago

sameergupta60 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.