Notes on spreadsheet formulae and CAR

« Back to posts
  • Viewed
    times

Filed under

  • google refine
  • grel
  • postcodes
  • spaces
December 13, 2010

GREL: Remove spaces from a column

  • Edit
  • Delete
  • Tags
  • Autopost
Click on Edit column > Add column based on this column...

Then type the following expression:

value.split(" ").join("")

This splits the value at every space (" ") and joins them with no space ("")
  • 0 responses
  • Like
  • Comment