Regular expression in query activity

Avatar

Avatar

salvdangelo

Avatar

salvdangelo

salvdangelo

14-02-2018

Hi,

I would like to exclude all those deliveries belonging to MESSAGE CENTER with internal name that ends with "_rt"

regex1.JPG

I cannot use the expression "CONTAINS '_rt' "  because I will get also "notifyStockAlert" for no reason so I am forced to use a regular expression, something like "LIKE '*_rt'  "

Could you tell I should I write this regex ?

Thanks,
Salvatore

Jean-Serge Biron

dattarays70361342

Amy_Wong

Debbie

Jochem van Dieten

clawson

mghalpin

Adobe Campaign

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Jean-Serge_Biro

MVP

Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
MVP

14-02-2018

Hi Salvatore,

Take care, in SQL expressions / SQL RDBS engines, most of time the wildcard specials chars are:

% (and not *) for strings

_ means 1 char to replace

so _rt means art, brt, crt, etc. So the "StockAlert" matches it.

To use the _ sign you must escape it, usually \_ but the syntax may depend on the SQL engine.

Reminder: the SQL expression syntax is not the same than regex syntax (used in Javascript or other development languages).

Regards
J-Serge

Answers (0)