I need help for coding a merge function.
I wrote a prototype that works fine using that merge schema: I took a test file to load and another text file who have missing entries and it works fine. But once it came the time to enlarge that method to accept unknow merge text file, the troubles starts.
Below is my Merge window:
On the left: the Heading for the target ListBox,
On the right, the Headinf-g from the (text) file to Merge.
As you can see, I can have a different set of columns and, on screen (that window), I can set the Right Headings to the Left Headings, but once I am there, I am totally unable (since weeks) to go ahead.
I need a direction to how I can take the merge text line(s) into the right colum. Doing so with know contents is easy, doing it from dark (a multi purpose load following the user schema) is where I am lost.
Actually, I have something like:
// If the loaded line have to be added [code OK]
LocRow = ListBoxTarget.ListIndex
// Then I have a set of:
ListBoxTarget.Cell(LoopIdx,LocRow) = NthField(Loaded_Line,Chr(9),CellNbr) // What CellNbr ???
end of loop[/code]
Thank you for a tip that will help me to make the code working as in the window screen shot case above (or any other case).
PS: forgot the date area in top-right: I added it, but I do not think it will stay there (as I use everywhere ISO 8601 dates).
Also, the value on the right listbox is a value stored in the RowTag corresponding to each Row entry.