Construction Site 34 Gate#5493 - 1234 4444 7777 3456
I have an expression like the one above where there can be up to 7 of these 4 digit Job IDs. for each job ID I get a company using a query and then filter the report where I grabbed this expression to each company folder.
But in order to do so, I would need to get a count returned on how many 4 digit values are returned AFTER the dash, and for each value found, run my query and save to folder.
Is there a way to use regular expressions to grab the count after the dash of 4 digit values and then be able to use each value in a loop?