Skip to content
Advertisement

Use Regex to Exclude any values that do not have a letter

For example, column below:

My desired output would be:

I tried this but no luck:

UPDATED EDIT:

Data Type = VARCHAR(16777216)

Advertisement

Answer

on snowflake this works:

gives:

And given REGEXP is an alias for RLIKE this also works

given these behave like LIKE which is a non-greedy match, the wildcards are needed to match all the prior and after tokens.

also works

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement