Re: [chat] Some Technical people!

[Stuart Cooper <scooper@xxxxxxxxxxxx>]

Hi Grant,

> Urgently needed, someone to help a Technical support manager to load a
> comma delimited message into Excel :-)
 
> The email this person's refering to had a simple list like so:-
 
> login,password,company name
> blah123,xyz123,The Blah Company
> tFHS1243,abc123,The File Handle Service company
 
> I didn't bother including it as an attachment.

This is the most visual, yet Linux-based was I could think of doing it:

Save your list to a file 'blah.csv' (rename blah as appropriate).
Open it up with star office:
$ soffice blah.csv
(if you've already got Star Office running, choose File/Open and give the
Linux pathname to blah.csv)
Say 'yes' to any questions that Star Office asks you.

Page through this spreadsheet and check that the fields look OK. If you
have any commas in blah.csv that were part of the data and weren't comma
separators your spreadsheet might be out of whack, you should be able to
see this by inspection. If you had a comma inside a string like
scooper,25,"Stuart Cooper, SLUG poster"
it will be handled OK.

Then use 'Save as' to save it in a Microsoft Excel format, it will become 
blah.xls.

blah.xls is now an Excel spreadsheet that can be opened in Excel.
You can email it as an attachment to the tech support manager.

> Thankyou for your assistance
> Unfortunately I am not as computer literate as some people expect me to be.

> <censored name>
> Technical Support Manager
> <censored company name>

Mmmm a technical support support manager who is not computer literate...
a bit scary. Hopefully he is taking the time to learn stuff; hopefully he
is also using his own technical support staff to help him out.

Good luck,
Stuart.