Delete text following after a given keyword

Topic Labels: Formulas
995 2
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

hi dear airtable community,

i have a colum named “size” and it contains for example the following text “45 1/3 EU - 11 US - 250€”.
now i am trying to find a function that will delete everything after “EU”, so it looks like “45 1/3 EU”. i already saw a bunch of formulas in here but somehow none worked. downloaded the scripting app by airtable and added codes like “LEFT({size}, SEARCH(“EU”, {size})-1)” but then i get an error message saying " ERROR ReferenceError: LEFT is not defined at main on line 1" and i dont know what it actually means.

any help is highly appreciated, thanks for your time and help!

Kind regards Karim :slightly_smiling_face:

2 Replies 2

Welcome to the community, @kxr1m!

You need to create a formula field with that formula, not use the scripting app.

Welcome to the community, @kxr1m! :grinning_face_with_big_eyes: Please mark Scott’s comment as the solution to your question. This helps others who may be searching with similar questions. Thanks!