Skip to main content
Solved

Remove TM from front of recipe

  • January 27, 2023
  • 2 replies
  • 22 views
J
Forum|alt.badge.img+3
  • jm22
  • New Participant
  • 4 replies

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

Best answer by TheTimeSavingCo

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

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

2 replies

TheTimeSavingCo
Forum|alt.badge.img+31
  • TheTimeSavingCo
  • Brainy
  • 6416 replies
  • Answer
  • January 27, 2023

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

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

Adam, Airtable Consultant - thetimesaving.company
J
Forum|alt.badge.img+3
  • jm22
  • Author
  • New Participant
  • 4 replies
  • February 7, 2023

it worked!! 


Terms & ConditionsAccessibility statement