Skip to Content

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

3 Comments
You must be Logged on to comment or reply to a post.