power lists - validate against underscores

  • 1
  • Problem
  • Updated 1 month ago
In the process of wanting to clean up power lists of generic names, I am testing with underscores to exclude any name that contains two underscores. When I do that, the PL returns 0 record. When I remove that parameter, I get my 200+ records. Clearly, underscores makes it go bizzurk!

Rule Name:CSM contacts for MONTHLY STATS
Rule Criteria:
..... (kept just a few entries here)....
AND NOT JBCXM__Contact__r.Name LIKE '%Information%'
AND NOT JBCXM__Contact__r.Name LIKE '%Contact%'
AND NOT JBCXM__Contact__r.Name LIKE '%__%'
Photo of Diane Morneau

Diane Morneau

  • 1,070 Points 1k badge 2x thumb
  • amused by this reaction!

Posted 3 months ago

  • 1
Photo of Sai Ram Pulluri

Sai Ram Pulluri, Official Rep

  • 9,960 Points 5k badge 2x thumb
Hi Diane, Sorry for the delayed response,Is the issue still exists?

For a better help on the above use-case, can I raise a support ticket.

Changing this to a problem post.