In other words, is it possible to exclude the " around the search_text?
If not, is there a way to add the " without it preventing the calculation?
For example:
FIND(aTextField, anotherTextField)
Another example:
FIND( SUBSTITUTE(aTextField, "this", "that"), anotherTextField)
6 réponses
This may be a limitation on the process builder. I copied your formula into a formula field on the Task and it works as you expected. Note that I changed the reference to a custom text area field (text_area__c) because I am not allowed to use the standard Description field in the formula.
MID(
Text_Area__c,
FIND("Text B: ", Text_Area__c) + 8,
(
FIND(
SUBSTITUTE($Label.LineBreak, "-", ""),
Text_Area__c,
FIND("Text B: ", Text_Area__c) + 8
)
-
(FIND("Text B: ", Text_Area__c) + 8)
)
)
returns "This one is B"
