How exactly does the pattern of the file output work? Is there something
that identifies parts that you want separated into different arrays?

"Excel User" wrote in message
...
Hi,

I'm hoping someone can help, I have an output from a file:

{"forename":["Forname1","forname2"],"surname":["Surname2","surname2"],"dateOfBirth":["04\/07\/1970","05
\/27\/2009"]}

I would like to convert this into a loop

array1 = "forename1", "surname1", "04\/07\/1970"
array2 = "forename2", "surname2", "05 \/27\/2009"
etc

for each x
'do something
next

I don't mind skipping creating the arrays but don't know who to do this?

Thanks