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

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

Howard,

forename is the header
surname is a header
as is dateOfBirth

then the values are each a

1st set
forename1, surname1, 04\/07\/1970
2nd set
forename2, surname2, 05\/27\/2009
etc

Thanks

"Howard31" wrote in message
...
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