You are currently looking at Flamebate, our community forums. Players can discuss the game here, strategize, and role play as their characters.
You need to be logged in to post and to see the uncensored versions of these forums.
Viewing a Post
|
I knew I’d learned something useful from making my useless replication of the ‘moar files sortable by attribute’ page (didn’t know it existed before I made my own), namely how to manipulate large wiki-formatted tables by combination use of spreadsheets and text editors.
To make sure everything was sorted into order my process was to dump it all into a spreadsheet, write a lookup formula and duplicate it (and slightly modified versions thereof) onto 4 columns and several hundred lines to get everything in place – one table row at a time.
Copy that to notepad and back to remove the formulaic part and just keep the text, so it could then be sorted by one column. To get it back onto individual rows I copied it from the spreadsheet to Word (which replaces column breaks with tabs) then did Find+Replace to put in a newline for each tab, putting everything back onto individual lines like the wiki likes it.
I maintain that this was far easier than going through by hand. YMMV man-man edited this message on 06/24/2009 11:42PM |
||||||
Posted On: 06/24/2009 11:42PM | View man-man's Profile | # |