?

Log in

No account? Create an account

Previous Entry | Next Entry

Happiness is...

I love parsing through a comma separated value text file on my workstation, especially when it's just small 414 MB file, and I have to load it into memory. *taps foot* All this in the name of finding some old funky computers on our network that probably aren't even around any more.

Sure beats doing this by hand....

Comments

( 9 comments — Leave a comment )
zarchasmpgmr
Oct. 25th, 2004 11:51 pm (UTC)
I ass/u/me that reading into Excel was not an option. (Can Excel parse that many lines?)

Or processing on a Real Computer (that z/OS thing hiding in Monterey Park).
rialtus
Oct. 26th, 2004 04:07 am (UTC)
Excel is not an option. Actually, neither was scripting because it was too large. I had to import into Access (since I had no SQL server available to me on my workstation on the train ride home).

And that real computer ... I'd either have to do DB2 or parse with REXX, which I'd rather not do, ya know?
zarchasmpgmr
Oct. 26th, 2004 04:16 am (UTC)
Object REXX works well on toy computers, and I thought I saw something where IBM now made it open-source on the non-EBCDIC platforms.

I'm surprised that Access didn't shit its biscuits on a file that size, though.

I hear ya on the DB2 stuff, though.
rialtus
Oct. 26th, 2004 04:27 am (UTC)
Actually, of the options, REXX and VBScript are really the easiest... Object REXX I've never bothered with, mainly because I knew too much REXX and knew nothing of OOP...

My laptop has 1 GB of memory (*grin*) and there were only 1,587,742 distinct lines... It helped that I only brought in the relevant columns that I needed...
zarchasmpgmr
Oct. 26th, 2004 04:30 am (UTC)
Just because it says "Object" doesn't mean you need to know OOP. :-)

I ported a C program from z/OS to WinXP C++, and the only reason it was C++ was to use Windoze's XML stuff. Heck, despite it being a C++ file, only one subroutine was truly C++, the rest was C.

My work-provided Dell Latitude is 512MB. I'm thinking of buying my own upgrade.

So were you able to accomplish what you were wanted to accomplish?
rialtus
Oct. 26th, 2004 04:40 am (UTC)
Until recently, I also only had 512 MB. But since I've been using Virtual PC for some of my work, I had to bump it up to 1 GB.

And yes, I was able to get what I needed - parsing through 1,587,742 lines just to get 1,603 records. What a royal pain in the ...

The worst part is that there will likely only be about 300 of those records that will be effectively used. *grr*
zarchasmpgmr
Oct. 26th, 2004 04:54 am (UTC)
Virtual PC

Is that the same as VMWare, who, if you believe their marketing stuff, invented virtual machines? (*cough*IBM*cough*)

300/1578742 = 0.019% But... 1603/1578742 = 0.1%. 300/1603 = 18.7% So your work bore fruit. :-)
rialtus
Oct. 26th, 2004 05:19 am (UTC)
Virtual PC <-> Microsoft's rebranding of Connectix's product, which was a competitor to VMWare prior to being acquired by the large Redmond company. VMWare is better (example: it natively supports USB drives, where Virtual PC doesn't), but Virtual PC is significantly cheaper and does what I need it to.

*cough*IBM*cough*Unix*cough*

And my work will hopefull bare fruit in the fact that we should be able to find some cruddy old Win 9x and NT 4 workstations that are still around, with the sole purpose of REPLACING THEM finally...
zarchasmpgmr
Oct. 26th, 2004 02:42 pm (UTC)
Ah. I've always pondered this...

If you have VMWare, can you run a *n*x image on a Windows platform, and vice versa, or is it its own operating system that boots up, then boots up the guest OS a la z/VM with the other OSes?
( 9 comments — Leave a comment )