Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

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...

Need Help

tex628
7 years ago
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!

Anonymous

Not applicable

7 years ago

Hi Kalpavruksh,

do you mean to change the format in Power Query?

Because when I did it then I couldnt use replace function

Thanks

Lukas

tex628

Community Champion

7 years ago

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!

Anonymous
Not applicable
7 years ago
Hi tex628,

your solution worked perfectly :)

Thank you
Lukas
Anonymous
Not applicable
5 years ago
This worked well, thank you!