OK, first off, I cannot begin to describe how much i love the new Text List object - with just a scrawny bit of code I can load a tsv text file with a random number of fields and arbitrary text before the field headers and have it populate a text list, complete with column names and adjustable width:
catcherror("nothing selected yet)", ignore("",assign(fileload(fg_folder+fg_chosenfile),"fg_filecontents"))+fg_filecontents[search(fg_filecontents,"Column")+7,-1] )
If I click through the other files in the folder, I can verify that the fields are correct, because changes update automagically and manual adjustments to field widths are preserved. And none of these things affect the original file- its all in a variable! Stunningly great!
Here are two questions- Can i procedurally make some of those columns less wide? (some of the fields are useless to me, some of the time.) I know that i can eliminate data with an arrayfilter but given that i don’t necessarily know the field name/order, i don’t want to do anything i cant quickly undo in this preview window) Also, i know I can drag records up and down, but is there a way to manually drag columns into a new order?
ok sometimes “a couple” means three…
Now that importusing has left the building, it looks like importtext is the way to go, for semi-automatic text imports? I want to build a mini “import workshop” that will keep a persistent list of fields to rename or recalculate as i import them into my ‘complex database’. (all the list data in in a variable, at this stage of the pipeline)
cheers from the tropical island!!