Keep only alphabets and numbers

3 followers
0
Avatar

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

Dean Villegas Answered

5 comments

  • Avatar
    Dean Villegas

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

    0
  • Avatar
    Brian Junio

    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
Please sign in to leave a comment.