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.
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.
i tried but no result
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
