Alteryx Designer Desktop Discussions

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

filter a pattern

PassION_es
9 - Comet

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
14 - Magnetar

@PassION_es is there any sample input or expected output?

 

Raj
14 - Magnetar

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

please mark as done if this is solved.

PassION_es
9 - Comet

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

Labels