Buy Official Merchandise!
Forumwarz is the first "Massively Single-Player" online RPG completely built around Internet culture.

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.

Log in or Learn about Forumwarz

Civil Discussion
Switch to Role-Playing Civil Discussion

Viewing a Post

man-man

Avatar: 156485 2010-01-24 16:36:14 -0500
24

[Harem and Sushi Bar]

Level 69 Hacker

Selfish fine upstanding member of society

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
Internet Delay Chat
Have fun playing!
To chat with other players, you must Join Forumwarz or Log In now!