Match pattern in google sheet

Hello,

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

How can I set this up? Anyone?

I did it using 3 modules It assuming value1 is always animals and 2 and 3 are eats.

Welcome to the Make community!

Yes, that is possible. You’ll need a minimum of one module:

Screenshot_2024-10-01_081024

This is just an example. Your final solution may or may not look like this depending on your requirements.

Hope this helps! Let me know if there are any further questions or issues.

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

1 Like

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

Thank you for your assistance, the route @samliew mentioned works best for me. Nevertheless, thanks again!