Skip to main content
Solved

Removing Lines After a Specific Text

  • May 30, 2024
  • 2 replies
  • 34 views

Forum|alt.badge.img+1

Hello everyone! I'm a new member in the airtable community and wanted help on my airtable problems. 

I currently have a base table that receives emails, the problem currently is that it saves the whole email chain instead of just the email itself. I wanted to ask if there's a way (scripting/formula) to automatically remove  lines of texts after the word "From:" for every new entry that comes in. 

 

Thank you! 

 

Best answer by TheTimeSavingCo

Try:

 

TRIM( LEFT( Notes, FIND( "From:", Notes ) - 1 ) )

 

2 replies

TheTimeSavingCo
Forum|alt.badge.img+31

Try:

 

TRIM( LEFT( Notes, FIND( "From:", Notes ) - 1 ) )

 


Forum|alt.badge.img+1
  • Author
  • New Participant
  • May 30, 2024

This works! Thank you!