SOLVED
Wild Card Search
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
TripleJJJ
7 - Meteor
‎04-17-2024
12:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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,
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
2 REPLIES 2
16 - Nebula
‎04-17-2024
12:20 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
‎04-17-2024
01:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you! Worked perfect!
![](/skins/images/3FF7D57F745C704215A0334244571C8C/responsive_peak/images/icon_anonymous_message.png)