Salesforce IdeaExchange

REGEX Formula Syntax is Based on Java, Does Not Search Entire Field

We are using Email to Case and trying to use the REGEX formula to search for keywords in the body of the email and update a field using workflow rules. The issue is that since the REGEX formula uses Java, if there is a line break original message the formula will not work. Therefore, the workflow rule will only work if the code is in the first line and not preceded by or followed by a line break. We would like the formula to work so that it picks up the keywords from anywhere in the body of the email.

eanna 09/19/08	Yes, the problem here is that the regex . wildcard, which matches any character, does not match line breaks (carriage returns, newlines etc). So .[a-zA-Z]+. would match "6^&%^&test%^" or "124test $%*" but not "test "
marilynl 09/29/08	Changed status to Large Enterprise Ideas.

track comments for this idea

Please log in to post a comment

recently promoted by:

bolaurent
joseph_ferraro
AlexCRMmanager
eanna
MattBizup

Resources

Ideas Under Consideration

Successforce.com

REGEX Formula Syntax is Based on Java, Does Not Search Entire Field - Salesforce IdeaExchange

Salesforce IdeaExchange

REGEX Formula Syntax is Based on Java, Does Not Search Entire Field

Search Community

Categories

1-800-NO-SOFTWARE | Privacy Statement | Security Statement