Business Rules - checking customer thread for data in cells
Content
We have a supplier that processes our invoices and feeds back the results as successes or failures. In our rules I need to split out the successes from the failures. The format has always appeared as:
Processed Accepted Failed
1 1 0
Processed Accepted Failed
1 0 1
And I could search for the 1 1 0 or 1 0 1 by copying and pasting this into a rule. They have now changed the format of the email and the data appears in cells:
Processed
|
Accepted
|
Failed
|
1
|
1
|
0
|
Any idea how I could search for this in a rule. I tried copying/pasting, but that did not work. There is no other data in the body except for very many specific error messages that I could search for. Any help would be greatly appreciated.