Formula functions to return a text value
I have three fields that each return the body of an html email. The first, which is named [Body], returns the entire email with html tags included: <html><head> <meta http-equiv="Content-Type" c...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendwhen you use this sytax
it means to take the left of the body field up until any of the delimiter characters f, r, o, or m.
Instead, you should do a SearchAndReplace replace to replace the "from" with say a vertical pipe | which is an unlikely character to be found in emails, and then hook onto that pipe character.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
If ( Contains([Body Field], "From"), Left([Body Field], "From"), Length([Body Field]) > 0, [Body Field] )it means to take the left of the body field up until any of the delimiter characters f, r, o, or m.
Instead, you should do a SearchAndReplace replace to replace the "from" with say a vertical pipe | which is an unlikely character to be found in emails, and then hook onto that pipe character.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Yes, that worked!
I changed the formula for 'Email Body' to:
------------------------------
AR
------------------------------
I changed the formula for 'Email Body' to:
var text bodyField = [Body Field];
var text replaceStart = SearchAndReplace($bodyField, "From", "|");
var text replaceEnd = Left($replaceStart, "|");
$replaceEnd
and I was able to extract the most recent email thread. Thanks, Mark!
------------------------------
AR
------------------------------