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.
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.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.