I have table that lists the directory structure in a real bad way and would like some assistance in simplifying the creation of a table show the folder structure in a tabular way ie; left to right on a single line.
I'm not sure that I really understand what do you you want to do but I think I would try it with something like this:
load *, rowno() as RowNo; load recno() as RecNo, iterno() as IterNo, String, subfield(String, Delimiter, iterno()) as SubString from Source while substringcount(String, Delimiter) <= iterno();
Subfield() will split your String into multiple records. RecNo and RowNo enable you to track the source- and target-records and IterNo the respective depth of the SubString.
Before and afterwards you will probably need various string-operations with replace(), keepchar() and also left(), right(), mid() and similar functions to prepare the String and to correct the created SubString appropriate.
The next step could be to create a mapping-table of foldernames in regard to the depth of the SubString - maybe just loading the split-results with an appropriate where-clause - and then loading the result-table again and replacing the depth-information with the foldernames.
Afterwards this result could be string-aggregated with concat() to a complete path.
I'm juggling about a dozen things at the moment so thanks for the input, I did a quick run through using the above but had to stop at 500 million lines ( I think I missed something) I will try and look again later this week