Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

filter a pattern

PassION_es
10 - Fireball

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.

 

3 REPLIES 3
Raj
15 - Aurora

@PassION_es is there any sample input or expected output?

 

Raj
15 - Aurora

@PassION_es 
use this 
Regex_Match([Field1], '\d{4}-\d{4}-[A-Z]\d')

please mark as done if this is solved.

PassION_es
10 - Fireball

Hello @Raj , please see attached snippet. Only the ones highlighted in yellow should be filtered by Alteryx. 

Labels