Randomthots <[EMAIL PROTECTED]> wrote:
>Try this: Go to ftp://ftp.arin.net/pub/stats/arin/delegated-arin-latest.
>This is a bunch of statistics on Internet number registries for the >American Registry of Internet Numbers. It's a character-delimited text file >-- like a csv but the delimiting character is a pipe "|". It has 52670 rows. >Save it on your hd with an extension of .csv. Open it in Excel.
I got this far on my WinXP system and I had issues. In order to open this file correctly in Excel 2003 - i.e. using "|" as a separator - it is necessary to make a *global* change to the system, as follows:
Click the Windows Start menu. Click Control Panel. Open the Regional and Language Options dialog box. Click the Regional Options Tab. Click Customize. Type a new separator in the List separator box. Click OK twice.
This changes the list separator for *all* applications.
When I open with OOo, by contrast (1.9m100), it asks me what the separator character is, then loads the file correctly into multiple columns.
Add the fact that in order to find out how to deal with the situation in Excel, I had to use MS online help.
At this point, I think my MS Office CD would be assisting in experiments in the microwave :-). Performance becomes less relevant in this particular case.
Incidentally, having saved it as an .ods file, reloading it took 1m26s on my Inspiron 1150 notebook. I really couldn't be bothered to carry on the experiment with Excel. How much memory on your system, BTW?
Regards -- Martin Taylor
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
