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
1 Like
Solved it!
Included in next release.