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 ("")