Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Use REGEX to filter emails

Avatar

Level 4

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

2 Replies

Avatar

Community Advisor

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

Avatar

Correct answer by
Community Advisor

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