Doh! (#578)

Home

Ongoing Excel / PERL stuff

Nov
272003
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)...

TweetComment / reply

Too many fields appear to be blank

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...
27 Nov TweetComment / reply

Doh!

Should have checked right away, those lines in the excel file actually were blank... going to work on a few previous months listings now!
28 Nov TweetComment / reply

How to convert an Excel date to a UNIX date

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;


27 Nov TweetComment / reply

Paul Clarke's - I live and work in Hythe near Folkestone, Kent. married to Clare and father to two, I am a code engineer, and I do mostly js, Node, python, ruby, and php. I like pubbing, restaurants, home automation and other diy jiggery-pokery, history, genealogy, TV, popbitch, squirrels, pirates ☠, lego, and time travel.

Also from the same week

Some more blog posts from the same week as .

Warner Village Islington Going to the cinema tonight to see Pirates of the... [Sun 17 August 2003]

Pirates of the Caribbean is ace Well worth going to see, and Warner Village Islington... [Sun 17 August 2003]

Pirates of the Caribbean MISSTEAKS (and spoilers) I thought of a few of things about the film - if... [Mon 18 August 2003]

Stoke Newington Cinema While I'm in this thread I should give a mention to the... [Mon 1 September 2003]

Keira Knightly Masturbation Stories No, not really, but I just got a search referral saying... [Mon 1 September 2003]

Crawler Sending out a crawler today to search Google for things... [Thu 13 November 2003]

RE: Crawler I actually got a hit with referer URL... [Thu 13 November 2003]

Lordy worked quicker than I thought, thanks for the feedback.... [Thu 13 November 2003]

Google API's I'm using the Google API's to query Google for pages... [Thu 13 November 2003]

Here's the link that is showing up in my referrers... This link: clarkeology.com/stokey/51/9/ ...was in my... [Sun 16 November 2003]

War On 106 Exciting, seems being pissed off with bus route 106 is... [Wed 19 November 2003]

stellastarr* Stellastarr* play Islington Academy today, the venue in... [Mon 24 November 2003]

Baby, baby, where did the month go? I am amazed it's the 24th already! I forgot I have... [Mon 24 November 2003]

RE: stellastarr* Hiya... I just discovered your site while doing a search... [Mon 24 November 2003]

RE: stellastarr* p.s. my e-mail addy is: t_ferrino2k@yahoo.co.uk (on... [Mon 24 November 2003]

stellastarr* Last night's Stellastarr* gig at Islington Academy... [Tue 25 November 2003]

Stellastarr* THEY'RE ACE. [Tue 25 November 2003]

Perl / Excel Programming idea for the day! Instead of me trying to... [Tue 25 November 2003]

Perl and Excel Found some handy documentation at IBM.com of all places. [Tue 25 November 2003]

RE: Crawler and I got one today from clarkeology.com My site is... [Tue 25 November 2003]

Daily productivity Sorted out a mailing list oddity that was left over from... [Tue 25 November 2003]

Maybe Stokey prices aren't falling... Our neighbour on the other side has also just gone up... [Tue 25 November 2003]

Where does all this water come from? Water is still streaming into the flat, seems to be... [Wed 26 November 2003]

Want some shoes? Oh, and tickets to a cheeky ESP gig... [Wed 26 November 2003]

Darkness download! Got the option to sell this download through the site...... [Wed 26 November 2003]

Leaky roof The letting agency sent someone round to look at the... [Wed 26 November 2003]

RE: stellastarr* I agree (in a way!). I thought the 22s were good and I... [Thu 27 November 2003]

Ongoing Excel / PERL stuff The PERL Excel project is coming along nicely, it takes... [Thu 27 November 2003]

Siegfried and Roy Wondering if this "Montecore says Get The Horn"... [Thu 27 November 2003]

Hands off our 73! Just remembered, while having some smashing drinks in the... [Thu 27 November 2003]

Bus route 106 Got an email from my flatmate this morning: Got the... [Thu 27 November 2003]

Too many fields appear to be blank In my ongoing perl / excel investigations, I'm finding... [Thu 27 November 2003]

How to convert an Excel date to a UNIX date Excel stores a date as the number of days since the start... [Thu 27 November 2003]

Very popular with Shoreditch types And another competition for you! You have all entered the... [Fri 28 November 2003]

IPOD's Dirty Secret Not sure what IPOD's Dirty Secret actually is, there's... [Fri 28 November 2003]

Popdex Not to be confused with my very own popex.com , Popdex... [Fri 28 November 2003]

Auto unsubscribes for Barfly Hmm, getting there with the auto unsubscribes for Barfly... [Fri 28 November 2003]

Banner Ads Nice one, just got two and a half grand in for... [Fri 28 November 2003]

Doh! Should have checked right away, those lines in the excel... [Fri 28 November 2003]

Welcome to the Cheap Seats Much drinking yesterday, crawled by the Pint Pot , the... [Sat 29 November 2003]

Curry and Mouse Poo TOP curry yesterday, went to Tayyab near Whitechapel... [Sun 30 November 2003]

Tayyab Apparently authentic Pakistani food, absolutely bloody... [Sun 30 November 2003]

Quicktime STILL can't watch it here, Quicktime won't install on... [Sun 30 November 2003]

Pirates of the Caribbean DVD Out Monday! [Sun 30 November 2003]

736 emails today Probably all spam , still at least no problems getting... [Mon 1 December 2003]

Good work If you put them up on the web, post a link to them here,... [Mon 1 December 2003]

Pirates of the Caribbean game There's a Pirates of the Caribbean for the PC starring... [Sat 3 January 2004]

Keira Knightly Wallpaper paper-flower has some Keira Knightly Wallpaper (not... [Thu 8 January 2004]

RE: stellastarr* Yeah, I went to this gig. I've seen Stellastarr* in every... [Wed 28 January 2004]

Hi Moker You're in the Ordinary Boys aren't you? [Thu 29 January 2004]

RE: Hi Moker Not on your nelly. Going to see Stellastarr* soon. It's... [Fri 30 January 2004]

Stellastarr new tour Stellastarr play Camden Electric Ballroom today, same... [Sat 31 January 2004]

RE: stellastarr* i hope you die of cancer [Tue 2 March 2004]

RE: Pirates of the Caribbean MISSTEAKS (and spoilers) 1) they turn into skellitons when they are in the... [Wed 3 March 2004]

RE: Keira Knightly Wallpaper Sparrow can slide down the rope with both hands bound... [Sat 19 June 2004]

miriam [Mon 28 June 2004]

New Home Of Me and My Monkey New Home Of Me and My Monkey [Wed 16 February 2005]

Upload a file [Tue 8 November 2005]

static site sofia pay day steep street chambers sourdough hythe bulgaria gymnastics hospital docker payers park weather shares center parcs volksfarmers swimming go ape orlando share save scottevest holiday vegan tax beetle mortgage follies harbour arm inn doors pizza working from home

Paul Clarke

Links

Latest

Todo:

Projects

Privacy policy