Help

Removing Lines After a Specific Text

Topic Labels: Automations Formulas
Solved
Jump to Solution
230 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!