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.

sameergupta60's avatar
sameergupta60
Helper IV
6 years ago

The source is SQL database

Attached screen shot 

 

amitchandak's avatar
amitchandak
Super User
6 years ago

sameergupta60 , if they are decimal in sql server database, try to change data type to decimal in edit query mode.

if it is a text, you need some code to do that