Parse Google Trends pseudo-API

[MartinVu]

Hi guys,


For some benchmark reports I want to add various external sources including Google Trends.
I found the following "hack" where you simply adjust the following URL

Please Login or Register  to view this content.

with the searchterm and get a long json-like text answer. Unfortunately, it is not json-compatible, so I am using the =Webservice() formula to get the result in xls, which looks like the following (shortened):

Please Login or Register  to view this content.

Now I want to write a macro to get a csv file that can be used as input for a DB that has two columns: data, value.
My specific issue is how to "iterate" through text that is in only one cell by using the specific "delimiters" available above such as "new Date(" and "f:".

I would appreciate any advice

Cheers
Martin

[AlphaFrog]

Perhaps this recent thread may help.

Transfer text file data to spreadsheet via vba