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

[cephasjames]

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]

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]

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]

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]

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]

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

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

[cephasjames]

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]

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]

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]

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]

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]

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.