Doh!
Home
The PERL Excel project is coming along nicely, it takes a long time to parse an Excel file, they're enormous... I've been working with a month's worth of gigs, just in partner venues in the UK, and that comes to about 1.1MB, so I opened it in Excel and trimmed out all but about 6 lines of it, and it STILL comes to half a meg, insane...
Think we might have MICE in the flat, Clare heard rustling in a cupboard, though it was too dark to investigate (ie I'm putting it off)...
pauly :: 2003 :: Comment / reply
In my ongoing perl / excel investigations, I'm finding that about 5 out of 6 rows appear to have blank info in them, this can't be right can it? Going to learn how to use Data::Dumper so as to investigate the spreadsheets further...
pauly :: 27 Nov :: 2003 :: Comment / reply
Should have checked right away, those lines in the excel file actually were blank... going to work on a few previous months listings now!
pauly :: 28 Nov :: 2003 :: Comment / reply
Excel stores a date as the number of days since the start of 1900, and UNIX as the number of seconds since the start of 1970, so the sum is:$unixTime = ( $excelDate - 25569 ) * 24 * 60 * 60;
pauly :: 27 Nov :: 2003 :: Comment / reply
Paul Clarke's blog - I live and work near Folkestone. Married to Clare and father to Harry, I am a web dev, and I like javascript, PHP, Folkestone Gerald, pubs, restaurants, history, genealogy, TV, music, popbitch, squirrels, pirates ☠, time travel, stained glass...
Also from the same week
Some more blog posts from the same week as .
stellastarr* [Tuesday 25 November 2003]
Stellastarr* THEY'RE ACE. [Tuesday 25 November 2003]
Perl / Excel [Tuesday 25 November 2003]
Perl and Excel [Tuesday 25 November 2003]
RE: Crawler [Tuesday 25 November 2003]
Daily productivity [Tuesday 25 November 2003]
Maybe Stokey prices aren't falling... [Tuesday 25 November 2003]
Where does all this water come from? [Wednesday 26 November 2003]
Want some shoes? Oh, and tickets to a cheeky ESP gig... [Wednesday 26 November 2003]
Darkness download! [Wednesday 26 November 2003]
Leaky roof [Wednesday 26 November 2003]
RE: stellastarr* [Thursday 27 November 2003]
Ongoing Excel / PERL stuff [Thursday 27 November 2003]
Siegfried and Roy [Thursday 27 November 2003]
Hands off our 73! [Thursday 27 November 2003]
Bus route 106 [Thursday 27 November 2003]
Too many fields appear to be blank [Thursday 27 November 2003]
How to convert an Excel date to a UNIX date [Thursday 27 November 2003]
Very popular with Shoreditch types And another competition for you! You have all entered the win some shoes and tickets to a gig one haven't you? [Friday 28 November 2003]
IPOD's Dirty Secret [Friday 28 November 2003]
Popdex [Friday 28 November 2003]
Auto unsubscribes for Barfly [Friday 28 November 2003]
Banner Ads [Friday 28 November 2003]
Doh! [Friday 28 November 2003]
Welcome to the Cheap Seats [Saturday 29 November 2003]
Curry and Mouse Poo [Sunday 30 November 2003]
Tayyab [Sunday 30 November 2003]
Quicktime [Sunday 30 November 2003]
Pirates of the Caribbean DVD [Sunday 30 November 2003]
736 emails today [Monday 1 December 2003]
Warner Village Islington [Sunday 17 August 2003]
Pirates of the Caribbean is ace [Sunday 17 August 2003]
Pirates of the Caribbean MISSTEAKS (and spoilers) [Monday 18 August 2003]
Keira Knightly Masturbation Stories [Monday 1 September 2003]
Stoke Newington Cinema [Monday 1 September 2003]
stellastarr* [Monday 24 November 2003]
Crawler [Thursday 13 November 2003]
RE: Crawler [Thursday 13 November 2003]
Lordy [Thursday 13 November 2003]
Google API's [Thursday 13 November 2003]
Here's the link that is showing up in my referrers... [Sunday 16 November 2003]
War On 106 [Wednesday 19 November 2003]
Baby, baby, where did the month go? [Monday 24 November 2003]
RE: stellastarr* [Monday 24 November 2003]
RE: stellastarr* [Monday 24 November 2003]
Good work [Monday 1 December 2003]
Pirates of the Caribbean game [Saturday 3 January 2004]
Keira Knightly Wallpaper [Thursday 8 January 2004]
RE: stellastarr* [Wednesday 28 January 2004]
Hi Moker [Thursday 29 January 2004]
RE: Hi Moker [Friday 30 January 2004]
Stellastarr new tour [Saturday 31 January 2004]
RE: stellastarr* [Tuesday 2 March 2004]
RE: Pirates of the Caribbean MISSTEAKS (and spoilers) [Wednesday 3 March 2004]
RE: Keira Knightly Wallpaper [Saturday 19 June 2004]
miriam [Monday 28 June 2004]
New Home Of Me and My Monkey [Wednesday 16 February 2005]
Upload a file [Tuesday 8 November 2005]
