Forum Discussion
help
0,<3.519307092255493E+09>, can convert in decmial format
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.
10 Replies
What is the data source?
Is this a single number or comma separated numbers ?
The source is SQL database
Attached screen shot
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 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.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.
thank you so much
