Forum Discussion
Convert text with commas into value
Hi all, My database has some numerical fields that come in text and some of them have commas, by the time to convert the text to a value, the comma disappear and my number become "bigger". For e...
Oh, I guess I misunderstood. Then replace "," with "." instead of blank.
I hope you are looking to achieve this...
Input
I've splitted the Data field into two parts i.e before comma and after comma. Duplicated Part2 field to be a decimal type.
Then added a final output field as below
FinalOutput = IF(VALUE(NumText[Part2Num])=0,NumText[Part1],NumText[Data])
Output