Skip First Value Of An Array?

In the "Cookbook", there is an example of scraping Google's suggested search queries. However, when doing so, it also includes the original search query as part of the array. Is there a way to leave the original keyword out? Or skip the first value of an array?

You might be able to do something with the INDEX function in Excel.

I'm thinking there might be a good use to create a slice function where you can "slice" out any piece of a 2D array.

Slice({11,12,13;21,22,23;31;32;33},0,0,-1,-1) => {11,12;21,22}

If I made such a function your problem could be solved through Slice(XpathOnUrl(),1,0) (skips the first row).

Humm... might be a fun saturday night challenge :smile:

1 Like

Solved it! :smile:

Included in next release.

Try it out in the latest beta Looking for SeoTools 6.0 beta testers! (updated 2016-11-03)