, Regex_Match in Data Base tools_SQL server

Question

Hello all,

I am trying to use the "Regex_match"  function using a in DB tool (Filter or Formula). I use SQL server.  I used CHARINDEX but nothing. The below example is used in the Designer and it worked fine --> "!REGEX_Match([col1], '.+\d\d\d\d.+').

Any suggestions?

Thank you in advance.

AngelosPachis · Accepted Answer

Hi @Antonis_Choustoulakis ,

Can you try using a Filter In-DB tool and then select to apply a custom filter with the following expression:

"Name_of_column_you_need_to_filter" NOT  LIKE '%[0-9][0-9][0-9][0-9]%'

I think that should do it, please let me know if that worked for you.

Cheers,

Angelos