Forum Discussion
Replace "." to "," does not work
Hi guys, I dont know why but replace does not work in some columns. Most of the values in the column are in the correct form (decimal numbers are separated by comma) except those 2 in the sc...
Hi Lukas,
The reason your replace is not working is because the dataformat is general. You are trying to replace string values while the column doesn't have defined format. If you first convert the column to text, then do the formatting you should get the proper result.
Assuming you're european this is what i advice you to do:
- Format the column to text
- Replace "." with ","
- Format the column to decimal number.
Hope it works!
I'm seeing this as well. I am trying to convert WW23'22 into WW23.22. For some it works but for others it doesn't. The column is text - I've never seen this behaviour.