Use REGEX to filter emails

Avatar

Avatar

RaulOcana

Avatar

RaulOcana

RaulOcana

06-11-2019

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

06-11-2019

Hi,

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

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

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

Answers (1)

Answers (1)

Avatar

Avatar

Raj_bounteous

MVP

Avatar

Raj_bounteous

MVP

Raj_bounteous
MVP

06-11-2019

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