Alteryx Designer Desktop Discussions

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

Regex exclude pattern

lhoffmeyer
6 - Meteoroid

I have a regex filter and includes variables that end in _0 to _10 

SumVar_0

SumV_1

SumD_10

SumW_6_10

 

REGEX_Match([Name],"^Sum.*[_[0-9]$|_10$]")

 

I have some variables that end in Sum_6_10.  I would like to exclude these from the filter.

Something similar to ?!_6_10.  I am not sure how to add this into the REGEX below?

 

REGEX_Match([Name],"^Sum.*(!?_6_10)[_[0-9]$|_10$]") did not work.

 

I am hoping a regex adept will be able to help me write a regex that says find any var ending in _0 to _10 and excluding any var ending in _6_10

 

TIA

 

 

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @lhoffmeyer 

 

You can use filter like below

atcodedog05_0-1643387290952.png

 

Hope this helps : )

 

jrsheppard
7 - Meteor

Use !REGEX_Match([Field1], ".+_\d_\d.*") as the filter expression for a dynamic way of filtering out sequences of "_digit_digit"

 

You can use the following expression to filter out only "_6_10": 

!(FindString([Field1], '_6_10') > 0)

 

 

Labels