Use REGEX to filter emails

[RaulOcana]

Hi guys,

I was reading that ACC understands REGEX using LIKE operator. So I used

@email LIKE '^[A-Za-z]+[A-Za-z0-9\._-]+@[A-Za-z0-9\.-]+\.[A-Za-z]{2,5}[\.]*$'

to filter all emails that matches the REGEX expression, however it its returning 0 results.

Is this the correct way to use it or am I missing something?

Thank you!

- Raúl

[Raj_Ganta]

Hi,

check if you can find a solution in the extensively discussed question. I think this should answer your question.

Constraint / dataPolicy on Email Address

[Jonathon_wodnicki · Accepted solution]

Hi,

Like is wildcard match in SQL, generally used with '%':

• SQL Server LIKE Operator By Examples

All supported RDBMS' in ACC ship with regex engines. E.g. for Postgres:

• PostgreSQL REGEXP_MATCHES: Extracting Text Based on a Regex

The desired functions can be used in ACC by adding to its function list or by turning off its whitelist via setting xtk:option XtkPassUnknownSQLFunctionsToRDBMS to 1.

Thanks,

-Jon