Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Removing Lines After a Specific Text

Topic Labels: Automations Formulas
Solved
Jump to Solution
681 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Nariesss
4 - Data Explorer
4 - Data Explorer

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! 

Nariesss_0-1717048886360.png

 

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try:

 

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

Screenshot 2024-05-30 at 2.17.26 PM.png

 

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try:

 

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

Screenshot 2024-05-30 at 2.17.26 PM.png

 

Nariesss
4 - Data Explorer
4 - Data Explorer

This works! Thank you!