|
||||
|
05-31-2006, 11:41 PM | #1 |
Hall Of Famer
|
Is there a method to the madness of the cities.txt?
I want an all Michigan League with player only coming from Michigan cities. I know I need to erase every city except the Michigan ones to do this (yes, I renamed it before I started changing things). Is there an easy way to do this? Are the cities organized in any way other than alphabetical? Any help would be great.
__________________
5000+ Generic Logos Free for the Taking FREE: Uniforms and logos for 500+ teams spanning 1871-present Great Lakes League: 10 Conferences, 100 Teams Pre-OOTP 23 Custom Cap & Jersey Template v3.0 by Deft and NoPepper (with layers from other various artists) that I use: Caps, Jerseys |
06-01-2006, 12:23 AM | #2 |
Hall Of Famer
Join Date: Jun 2002
Location: Canuckistan
Posts: 5,157
|
Not sure if you can open the txt file in excel and sort on a specifc column, delete all of those not michigan and bring it back into txt? Maybe?
|
06-01-2006, 09:00 AM | #3 |
Hall Of Famer
|
You can definitely do it in Excel, if you're good at that sort of thing.
1. Open the file in Excel 2. Delete every row without a state of Michigan 3. Save the file as a csv file 4. Rename the saved file nations.txt That's really simplified, assumes you somewhat know what you're doing. Gotta run! |
06-01-2006, 09:37 AM | #4 |
Hall Of Famer
|
Thanks, guys. I'm not too familiar with this but I'm willing to try it.
1. I opened in excel. It said the whole file couldn't load. Does that mean it's too big? 2. I see the columns with Michigan in it. Is there an easy way of isolating the rows that are not Michigan? EDIT: Nevermind... that filter thingy rocks 3. I've saved the file as a csv. That's comma delimited, correct? 4. Rename the file as nations.txt? Not cities.txt? I've seen you explain this before (to me actually) I just don't remember the reason. EDIT: I've just renamed it nations.txt and... wow! it opens in in notepad! That should do it, right? Thanks again.
__________________
5000+ Generic Logos Free for the Taking FREE: Uniforms and logos for 500+ teams spanning 1871-present Great Lakes League: 10 Conferences, 100 Teams Pre-OOTP 23 Custom Cap & Jersey Template v3.0 by Deft and NoPepper (with layers from other various artists) that I use: Caps, Jerseys Last edited by cephasjames; 06-01-2006 at 09:51 AM. |
06-01-2006, 09:56 AM | #5 |
Hall Of Famer
Join Date: Mar 2003
Posts: 9,004
|
link is borked. . .fixing!
Go to that link, get the US cities only cities.txt The game included cities.txt cannot be completely opened by excel, it is too big, by about 35,000 lines. It's too comprehensive! The alternate file is only about ~30,000 lines, and is easily opened in Excel. Open up the alternate cities.txt, sort by the state row, and delete what you want. I will have to write this up well later tonight, maybe with screen caps. Last edited by Raidergoo; 06-01-2006 at 11:09 AM. |
06-07-2006, 11:04 AM | #7 | |
Hall Of Famer
|
Quote:
__________________
5000+ Generic Logos Free for the Taking FREE: Uniforms and logos for 500+ teams spanning 1871-present Great Lakes League: 10 Conferences, 100 Teams Pre-OOTP 23 Custom Cap & Jersey Template v3.0 by Deft and NoPepper (with layers from other various artists) that I use: Caps, Jerseys |
|
06-07-2006, 11:08 AM | #8 | |
All Star Starter
Join Date: Apr 2004
Location: Not Here
Posts: 1,226
|
Quote:
__________________
Beer Snob and Baseball Sim Geek |
|
06-07-2006, 11:18 AM | #9 | |
Hall Of Famer
Join Date: Mar 2003
Posts: 9,004
|
Quote:
Thanks a whole bunch for this data! |
|
06-07-2006, 11:35 AM | #10 | |
Minors (Single A)
Join Date: Mar 2006
Posts: 67
|
Quote:
Considering that the first spreadsheet I ever owned (Visi-Calc for the Apple II in the late 1970s) was limited to a 64x256 grid, like the commercial says, "You've come a long way, baby!" |
|
06-07-2006, 11:42 AM | #11 | |
All Star Starter
Join Date: Apr 2004
Location: Not Here
Posts: 1,226
|
Quote:
Columns went from 256 to 16,000 Rows went from 64,000 to a cool Million.
__________________
Beer Snob and Baseball Sim Geek |
|
06-07-2006, 11:45 AM | #12 |
All Star Starter
Join Date: Apr 2004
Location: Not Here
Posts: 1,226
|
Dola,
they really overhauled the interface though. I think I like it, but it's been taking some time getting used to it. It probably doesn't help that I've been going back and forth between 2007 and 2003 throughout the day either.
__________________
Beer Snob and Baseball Sim Geek |
Bookmarks |
Thread Tools | |
|
|