2059 active members
  179 are online

Year

19

Day

330

Time

04:24:50

Guest
Login
snewsgnewsmessagegeneralfactioninventorycombatroom
Message CentreRPG CentreQuestion Centre
Archives » SWC XML Export and how to strip unwanted info?
Loftano Drak

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).


Kendall Holm

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


____________

SWC3dsUser.png
Loftano Drak

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 use VBA for it. Depending on your version you could also create a macro which does it for you.


Selatos


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
Myrhrai Isalia Rosiir

Learn XML parsing in Python like I am.

So much more versatile and easy.