I’m using a Zap that reads information from my Woocommerce site. The information is presented similar to below
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/21136db9-15bc-48e3-92d4-2c6b271a50dc.png)
I want to retrieve the _stripe_net value of 181.46, but the problem is that depending on the product sold, this value could be in any position from 6 to 9.
How can I create a step(s) that allows me to find out what is the column and retrieve the appropriate value.
I tried using string.find as per below
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/8d03de3d-7684-4d84-a491-48f8b6ba8f30.png)
which resulted on the following output…
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/11124208-8dca-449e-a7c3-a2a3310319e3.png)
But I don’t know how to use this to select the 8th value inside the <Meta Data Value> field.
Best answer by FalconOz
View original