, Regex_Match in Data Base tools_SQL server

[Antonis_Choustoulakis]

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 solution]

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

[Antonis_Choustoulakis]

Hi @AngelosPachis,

Thank you for your comment and for the solution.  It worked. I had used the expression 'not like" but not with this regex function. 

Cheers,

Antonis