I am going crazy.
I must be very easy, but I cannot make it work.
I have a google sheet (whatch new rows) with a column “Subject”.
Every cell is build like this [value1] - [value2] - [value3]
for example cell B2: Monkey - Nut - Apple
I need to split this with a [match pattern parser] to 3 variables
Animal = Monkey
Eats1 = Nut
Eats2 = Apple
That’s it, thank you. I knew it must be easy. I’m taking your tip to follow the academy very seriously. For now, I’ve at least been set on the right path