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.
Solved! Go to Solution.
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
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