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
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)