So I need to as a cover element to a stack of items. The cover of course is unique. Oh, and the data stream is crap; I need to sort and filter the data; detail table are acting up. So much hate.
Option 1: figure out what’s going on with the detail table. Of course, each cell of the detail table might has one of two background images. That’s what really started screwing me. Easy way is skipping the detail table, and training each line if the original csv as it’s own record. But I need a seperator. Obviously I could just compare the current record with the last record, but that only works if the last record is saved in a variable. A VARIABLE is something that changes. If I find one more thing that says “once you aasign a value, you can’t thank it”… But back to what I was thinking.
I don’t know. I just need to bang this out in the AM.
Sleep.
Update:
I have a dirty way. It will honestly take longer to type then to do. I’ll type it later. It is terrible.
Do I never posted this previous update and I have 15 minutes:
- Sort the CSV
- Process the CSV as individual records, save
- Process the CSV as individual records with the type changed to cover
- Merge together
- Sort again
No detail table, XML, XSL, or separate scripting.
Will that was a fail. Final:
- CSV to XML
- Sort XML with XSL
- Process XML as one record per line of CSV
- Process same XML with one record per change of key field
- Strip the tail of one XML file and the head of the other
- Slam them together with a batch file using type
- Sort one more time using the original XSL
- Done