Remove item from field
I have a field that has text like this:
Name one ---Ford Fiesta---
Name two ---FIAT PANDA---
Name three ---Alfa Romero 159---
The data has a name or business then ---, a name of a car and --- again. The name sizes vary and so does the data in between the dashes.
I need to remove the ---and the data here and again the trailing--- but keep the data before the first ---.
I just cant seem to find a calculation/script to do it. I would like to keep the original field intact if possible and have a new field with the correct data. I hope I am clear