Skip to Content
Author's profile photo Former Member

Selecting only alphanumeric data

Use the below regular expression function to select onlt the alphanumeric data from the source

match_regex(SQL_Latest_Employees.HRRA01_LAST_N , ‘[0-9A-Za-z]*’,NULL ) = 1

Assigned tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      If your character data is outside the pure ascii scope e.g. accented etc then...

      match_regex(SQL_Latest_Employees.HRRA01_LAST_N , '[\p{L}\p{Nd}]*',NULL ) = 1

      which will match against any unicode letter or decimal digit.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      This should match with the decimal digit 1 and 0

      Author's profile photo Former Member
      Former Member

      Sorry, I do not understand your comment there?