AnsweredAssumed Answered

Remove item from field

Question asked by daveealex on Nov 15, 2010
Latest reply on Nov 17, 2010 by daveealex


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