RegEX filter

[BautistaC888]

Hello,
I need to filter the rows with the words "HP" in any position. I tried to do it with a RegEX but i can't find the correct expression.

I will appreciate your help.
Thank you.

[AngelosPachis]

Hi @BautistaC888 

A not do sophisticated regex would be to look for "HP" with everything that may come before it or after it.

REGEX_Match([Nombre], ".*?HP.*?")

Not perfect, but it works for the given dataset

Hope that helps.

Cheers,

Angelos

[jdunkerley79 · Accepted solution]

A couple of suggestions:

Easiest is just a contains function:

CONTAINS([Nombre], "HP")

If you want to only match words of HP (rather than contains), something like: should work

REGEX_Match([Nombre], ".*\bHP\b.*")