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

2 Likes