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:
