Forum Discussion

ZintJoseph's avatar
ZintJoseph
Qrew Captain
7 years ago

Parse a string of text to remove part of the message

I have a Zapier connection and mailbox that formatted emails are sent to be parsed for information to add a record into QuickBase...this issue is that our mail system adds a generic message to the end...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Joey,
Nice to hear from you.

Not tested but try this.

var text RawText = [my text field];

var text InsertPipe = SearchAndReplace($RawText, "The information contained in this message is privileged","|");

NotRight($InsertPipe,"|")

AlexCertificati's avatar
AlexCertificati
Qrew Cadet
7 years ago
Always fun to see use cases in the wild for tools that were only recently implemented. Sweet.