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
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Use REGEX to filter emails

RaulOcana
Level 4
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
wodnicki
Correct answer by
Community Advisor
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
Raj_bounteous
Community Advisor
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

wodnicki
Correct answer by
Community Advisor
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