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,"|")

  • ZintJoseph's avatar
    ZintJoseph
    Qrew Captain
    7 years ago
    You rock Mark...that did it.
  • 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.