SOLVED
filter a pattern
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
PassION_es
10 - Fireball
‎05-08-2024
01:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Alteryx,
May I ask your assistance on what formula to use to capture or filter below pattern:
2024-0102-B1
2023-0806-B3
2023-1222-B1
Thank you in advance.
Solved! Go to Solution.
Labels:
- Labels:
- Developer
- Tips and Tricks
3 REPLIES 3
Raj
16 - Nebula
‎05-08-2024
01:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@PassION_es is there any sample input or expected output?
Raj
16 - Nebula
‎05-08-2024
01:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@PassION_es
use this
Regex_Match([Field1], '\d{4}-\d{4}-[A-Z]\d')
please mark as done if this is solved.
‎05-08-2024
01:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @Raj , please see attached snippet. Only the ones highlighted in yellow should be filtered by Alteryx.
