Keep only alphabets and numbers

Answered

Follow

Dean Villegas

• June 25, 2015 22:07

I need to keep only alphabets (a~z, A~Z, 0~9, " "). How can I do it using REPLACEALL?

0

• 

  Pablo Redondo

  • June 25, 2015 22:58

  Try this: REPLACEALL(#text;"[^a-zA-Z0-9\" \"]";"")

  2

  Comment actions Permalink
• 

  Dean Villegas

  • June 25, 2015 23:06

  Thanks Pablo. Is there a page in documentation that I can read further about it?

  0

  Comment actions Permalink
• 

  Pablo Redondo

  • June 25, 2015 23:18

  Each function will have good info on its functionality (e.g.: http://www.datameer.com/documentation/display/DAS50/REPLACEALL) and if you click on the "<regular expression>" link it will forward you to this page: http://docs.oracle.com/javase/tutorial/essential/regex/index.html. There is also a lot of quick and simple tutorials online about regular expressions. I find this one pretty helpful: http://www.zytrax.com/tech/web/regex.htm. Hope this helps.

  0

  Comment actions Permalink
• 

  Brian Junio

  • June 25, 2015 23:32

  I would try the following:
  REPLACEALL(#text;"~*\\W")

  The Expression is: /~*\W/

  Note: Inside the function above, the '\' is escaped by another '\'.

  I typically use the following site to test my expressions:
  http://rubular.com/

  1

  Comment actions Permalink
• 

  Dean Villegas

  • June 26, 2015 00:06

  Thanks. Really helpful

  0

  Comment actions Permalink

Please sign in to leave a comment.