Skip to main content
Solved

Remove TM from front of recipe

  • January 27, 2023
  • 2 replies
  • 31 views
J
Forum|alt.badge.img+3

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

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
    • February 7, 2023

    it worked!! 

      Terms & ConditionsAccessibility statement