QUESTION:
How can I find a comma, or n\a when using conditions?
ANSWER:
Comma is typically used to specify a list of values within the same field that should be "or'd" together, i.e. BillingState = massachusetts,mass. When the condition is added to the list of conditions, the comma is changed to a pipe (|) symbol and evaluated as an "or".
If looking for a field that contains a comma, i.e. "IBM, Inc.", can use a backslash (\) to escape the comma, i.e. "IBM \, Inc.".
If looking for a value that literally contains a backslash, will need to escape that also with another backslash, i.e. "N\A" would be entered as "N\\A".
