change the character

[Gabriel2020]

Good morning people, everything fine ?

I would like to change the character “,” to “.”, can you tell me what would be the best way?

[Daniel_Weikert]

string manipulation → replace

[mlauber71]

@Gabriel2020 here is a thread that might help you

replace the delimiters

@Subramanyam you could use the Column Expressions. I assume you would want to do something like switch the dot and comma (otherwise you would have both separators as dots - you can of course also do this). replaceChars(replaceChars(replaceChars(replaceChars(column("column1"),"," ,"#" ),".",","),"#","."),"\"","") Two things to note use an intermediate like hash to help the switch escape the quotation mark if you want to replace it [image]