Date : Wed, 03 Nov 2010 09:28:27 +0000
From : robert@... (Rob)
Subject: No wonder CompSci graduates are unemployed
On 3 November 2010 08:54, J.G.Harston <jgh@...> wrote:
> Rick Murray wrote:
>> 1. Proprietary database, runs in DOS, saves in mangled weird unknown
>
> Secretary: I'm going to be busy all afternoon because I've got
> to go through the membership list splitting peoples' names into
> firstname and surname.
>
> Me: Save as CSV, BBC BASIC proggy that replaces the first space
> with a comma, reload into Excel. Done in about 30 seconds.
Me: search web to see if it's been done before and discover Excel can
do it on it's own:
http://office.microsoft.com/en-us/excel-help/split-names-by-using-convert-text-to-columns-HA001149851.aspx
(can't time it as I've not got Office installed at the moment)
:-)
Rob