Forum Discussion
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.
The source is SQL database
Attached screen shot
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
can you guide us
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.