Wild Card Search

[TripleJJJ]

Hi there,

I am trying to do a wildcard search on a column that contains a bunch of characters.

Example of data

AEBAHD

ABEAHE

BABAHD

ABBEHD

I want to return or split the results or add a flag if the below criteria is met

A*B*HD   - (* being the wild card)

So 2 of the above records would hit this criteria.

Any guidance would be greatly appreciated!

Thanks,

[ChrisTX · Accepted solution]

Try the RegEx tool in Match mode with this Regular Expression:      A.+B.+HD

Or one of these functions in a Formula tool:

REGEX_CountMatches(String, pattern)
REGEX_Match(String, pattern)

Chris

[TripleJJJ]

Thank you!  Worked perfect!