Backstory: I have a list that has a yes/no field for "SLA met". This is calculated based on the difference in days between another two fields. If the difference is more than 14 days, the SLA is not met.
Once a week, I have a site workflow that looks at the last 7 days, runs a Query on the list for items where the SLA met field is "Yes" and dumps those into a collection variable "collVarSLAmet". Also runs a Query on the list where the SLA met field is "No" and dumps those into a collection variable "collVarSLAunmet".
Problem: These collection variables are being counted using a collection operation and saved into "countSLAmet" and "countSLAunmet", respectively.
These collection variables are also being regexp'd into a plain text variable by replacing the semicolons with <br> and saving it to "metSLAitems" and "unmetSLAitems", respectively.
It all seems to be working, except the count is off from the amount of items in the text variable. Here's the XML log:
As you can see, the count is 11, but the amount of items in the text variable is 9. However, there are two semicolons at the beginning of the collection variable(7th line from the bottom), I think these are counting as items!
In the "countSLAmet", the count is 27, but the amount of items in the text variable is 26. There is one semicolon at the beginning of the collection variable, that I also think is counting as an extra item.
Any ideas? Why are these extra semicolons happening, and is that the source of the counting error?