Regex Issue with Any

Help Activities
,
1

Hi, I am having issues after reading a cell for a pattern. I have selected to use ANY option in the regex so that I can get 0 to multiple instances of my pattern. How do I go about writing an if statement where bot will only proceed to do Scenario A if it got 1 match, Scenario B if got multiple matches and Scenario C if there are no matches. I originally used list.count as my condition but as seen in the screenshot below, the regex variable has multiple empty values.

image
image801×456 9.93 KB

2

Additionally, if it does come with a match, the list is stored like this

image
image957×132 4.07 KB

3

Ok, I figured out the issue; I cannot use ANY for the quantifier because it seems to return empty value if text does not match. I have since switched to At Least One and now no more problems.

2 Likes
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.