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.
Hmm, I'd do this in Query Editor. Right click on the column and replace "," with blank. Then change data type to number.