help

[sameergupta60]

0,<3.519307092255493E+09>, can convert in decmial format

[FarhanAhmed · Accepted solution]

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 · Accepted solution]

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]

thank you so much

[amitchandak]

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

Appreciate your Kudos.

[FarhanAhmed]

What is the data source?

Is this a single number or comma separated numbers ?

[sameergupta60]

The source is SQL database

Attached screen shot 

[amitchandak]

@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

[sameergupta60]

can you guide us

[FarhanAhmed · Accepted solution]

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.

[FarhanAhmed]

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.

[sameergupta60]

i tried but no result