Help

Remove TM from front of recipe

Topic Labels: Formulas
Solved
Jump to Solution
1026 2
cancel
Showing results for 
Search instead for 
Did you mean: 
jm22
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi there, 

I know how to get things off the end of a string but not the start!!! 

I have recipes that look like this 

 

Easy veggie, lentil and quinoa dahl with pita toasts (KIDS)
Greek salad with crispy chickpeas and potatoes
Miso eggplant with broccolini and edamame
TM Pan-fried salmon with creamy pumpkin millet
TM Moroccan spiced beef and lentils with carrot couscous

 

I want to create a field that has all the recipe names - but without the TM at the start. 

 

TIA

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Assuming it's always going to be "TM", you could try:

IF(
  LEFT(Name, 3) = "TM ",
  REPLACE(Name, 0, 3, ""),
  Name
)

Screenshot 2023-01-27 at 1.21.13 PM.png

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

Assuming it's always going to be "TM", you could try:

IF(
  LEFT(Name, 3) = "TM ",
  REPLACE(Name, 0, 3, ""),
  Name
)

Screenshot 2023-01-27 at 1.21.13 PM.png

jm22
5 - Automation Enthusiast
5 - Automation Enthusiast

it worked!!