22.7.11

Remove or replace a specific character in a column

You want to remove a space or a specific character from your column like the sign # before some number.


2 expressions does the same job:
  • value.split("#").join("")
  • This splits the value at every space ("#") and joins them with no space ("")

  • replace(value, “#”, “”)
    this look for every # ("#") sign and replace it with no space ("")