You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Business Rules - checking customer thread for data in cells

Received Response
27
Views
2
Comments
edited Jul 1, 2021 10:37AM in Agent Desktop 2 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!