Help

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

Solved
Jump to Solution
1540 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
17 - Neptune
17 - Neptune

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
17 - Neptune
17 - Neptune

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()`