Is there a method to the madness of the cities.txt?

cephasjames · 05-31-2006, 11:41 PM

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.

RBLwebguy · 06-01-2006, 12:23 AM

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?

battists · 06-01-2006, 09:00 AM

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!

More on this later!

cephasjames · 06-01-2006, 09:37 AM

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.

Raidergoo · 06-01-2006, 09:56 AM

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.

battists · 06-01-2006, 10:01 AM

Crap, sorry, I meant "Cities.txt" not "nations.txt"

But you're on the right track. Especially if you backed up first.

cephasjames · 06-07-2006, 11:04 AM

Quote:

Originally Posted by battists

Crap, sorry, I meant "Cities.txt" not "nations.txt"

But you're on the right track. Especially if you backed up first.

Always back up!

I got it figured out. You helped a ton, thanks.

jnshmoo · 06-07-2006, 11:08 AM

Quote:

Originally Posted by Raidergoo

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.

It's fully openable with Excel 2007 Beta!

Raidergoo · 06-07-2006, 11:18 AM

Quote:

Originally Posted by jnshmoo

It's fully openable with Excel 2007 Beta!

That's what I was hoping, but kept forgetting to ask.

Thanks a whole bunch for this data!

johnph77 · 06-07-2006, 11:35 AM

Quote:

Originally Posted by jnshmoo

It's fully openable with Excel 2007 Beta!

Then they've gone the unlimited route on spreadsheet size ala Corel QuattroPro. That'll make the purchase of the suite worth my while.

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!"

jnshmoo · 06-07-2006, 11:42 AM

Quote:

Originally Posted by johnph77

Then they've gone the unlimited route on spreadsheet size ala Corel QuattroPro. That'll make the purchase of the suite worth my while.

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!"

Not truly unlimited, but I weep for anyone who needs to work with a spreadsheet that taxes the new maximums.

Columns went from 256 to 16,000
Rows went from 64,000 to a cool Million.

jnshmoo · 06-07-2006, 11:45 AM

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.

05-31-2006, 11:41 PM	#1 (permalink)
cephasjames Hall Of Famer Join Date: Jun 2004 Posts: 4,218 Thanks: 1,495 Thanked 1,318x in 521 posts	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. __________________

06-01-2006, 09:37 AM	#4 (permalink)
cephasjames Hall Of Famer Join Date: Jun 2004 Posts: 4,218 Thanks: 1,495 Thanked 1,318x in 521 posts	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. __________________ Last edited by cephasjames; 06-01-2006 at 09:51 AM.

06-01-2006, 09:56 AM	#5 (permalink)
Raidergoo Hall Of Famer Join Date: Mar 2003 Posts: 8,403 Thanks: 104 Thanked 78x in 52 posts	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:45 AM	#12 (permalink)
jnshmoo All Star Starter Join Date: Apr 2004 Location: Not Here Posts: 1,226 Thanks: 0 Thanked 0x in 0 posts	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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

06-01-2006, 12:23 AM	#2 (permalink)
RBLwebguy Hall Of Famer Join Date: Jun 2002 Location: Canuckistan Posts: 4,283 Thanks: 35 Thanked 64x in 37 posts	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 (permalink)
battists OOTP Developments Join Date: Jul 2004 Posts: 17,189 Blog Entries: 7 Thanks: 31 Thanked 776x in 220 posts	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! More on this later!

06-01-2006, 10:01 AM	#6 (permalink)
battists OOTP Developments Join Date: Jul 2004 Posts: 17,189 Blog Entries: 7 Thanks: 31 Thanked 776x in 220 posts	Crap, sorry, I meant "Cities.txt" not "nations.txt" But you're on the right track. Especially if you backed up first.