database list

[Ray_Barber]

This has to be available without an intense for next loop. I have a set of folders with sub-folders with content.

I need a list such that it flows into Excel as {“January”,“Week 1”,“sale 1.txt”,“sale 2.txt”}.

I know how to get the contents of a folder, but how can I force the variable list to be: {parent1,child1,item1, item2} {parent1,child2,item1, item2} {parent2,etc… without doing count of and repeat until?

Or, if this is the only way, what is the most elegant way of phrasing it?

Thanks in advance

[karl]

This has to be available without an intense for next loop.

I have a set of folders with sub-folders with content. I need a list such that it flows into Excel as {“January”,“Week 1”,“sale 1.txt”,“sale 2.txt”}.
I know how to get the contents of a folder, but how can I force the variable list to be: {parent1,child1,item1, item2} {parent2,etc… without doing count of and repeat until?

Or, if this is the only way, what is the most elegant way of phrasing it?

I don’t get it, are you trying to make a tree-view? Anyway, this sounds like recursive programming and is as such an item in the “advanced” section of the book. If you want to do it safe and fast, take a look at JonsCommands’ walk folders osax command.
[/quote]