Fail to replace "." by "," in power query

[annahuo]

Hi,

I have encouterd an issue to replace the "." by "," in my requete. After applying the formula "Table.ReplaceValue(#"Colonnes permutées",".",",",Replacer.ReplaceValue,{"NOMINAL"})", the "." still exists and there is no ",". The data type is in text format. 

Does anybody encounter the same issue and succeed in tackling with it?

Thank you in advance.

[BA_Pete]

Hi @annahuo ,

You can try changing this section:

Replacer.ReplaceValue

to this:

Replacer.ReplaceText

Pete

[annahuo]

Dear Pete,

It works ! Thank you so much for this help 🙂

Best regards,

Anna