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.

How to separate out text into a field based on a specific word?

Solved
Jump to Solution
2488 3
cancel
Showing results for 
Search instead for 
Did you mean: 
NoCodeLearner32
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi there! I'm new to Airtable and trying to figure out how everything works. Let's say I have a cell that as the following information I inserted below: 

Beef Onion Burgers with Pickles

Ingredients:
2 hamburger patties
1 onion, diced
2 tablespoons ketchup
4 slices pickles
2 hamburger buns

How can I separate all of the text to the left of the word  "ingredients" into one cell? I basically am trying to extract the name of the recipe into its own cell.

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try something like:

LEFT(
  {Full Text},
  FIND(
    "Ingredients",
    {Full Text}
  ) - 1
)

 Which will give you this:

Screenshot 2022-12-31 at 10.28.01 PM.png

See Solution in Thread

3 Replies 3
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try something like:

LEFT(
  {Full Text},
  FIND(
    "Ingredients",
    {Full Text}
  ) - 1
)

 Which will give you this:

Screenshot 2022-12-31 at 10.28.01 PM.png

Hey! That worked! The only thing is I have some spaces before the text. Is there anyway to remove those spaces?

Sure, to do that put the formula above inside a `TRIM()`