As the topic says, I've got my xml exported files from the combine, but there's several surplus columns and when I use Excel or Googledocs, I do need to manually delete them.
What I'm wondering about is there any way to utilise Excel to perform some stripping of the data after I've exported the xml? I know some folks likely use some sort of parser with PHP or what not (as selatos mentioned on irc).
If its columns it takes less than a few seconds to do them by hand. Click the header of the column then use ctrl and select the other column headers then use the delete table columns on the tool bar or by right clicking. This will remove the columns and shift all the data over like it was never there
I already can do that, just wondering if there was a way to do it automatically each time so its consistent and if I wanted to do any data comparisons, I can just replicate the analysis/formula for each page.
You could select "record macro" in excel, delete the columns you want, and then save the macro somewhere to be able to repeat it again on a new xml export.
"On two occasions I have been asked,—"Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question."
- Charles Babbage