The Faerytail Family
  1984 active members
  217 are online

Year

20

Day

330

Time

08:12:16

Guest
Login
snewsgnewsmessagegeneralfactioninventorycombatroom
Message CenterRPG CenterQuestion Center
Archives » SWC XML Export and how to strip unwanted info?
Loftano Drak
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
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
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
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
Myrhrai Isalia Rosiir
Learn XML parsing in Python like I am.

So much more versatile and easy.


____________

GRAPH.ping