Luke Yelavich wrote:
Hi all
I have been given a spreadsheet, which I have exported to a csv file,
for use with a community website I am working on.
I have a nasty problem, where a lot of the sells have massive amounts of
whitespace. I am wondering whether there is a quick way to remove the
whitespace, either in the spreadsheet, or in the csv file? I am guessing
a regular expression could do it, but I am no regular expression expert.
Sed is probably your friend here (though you could also try tr, awk,
perl, python, ...).
I have a whole lot of sed links here [1], that lead off to sed
cheatsheets, etc.
[1] http://www.snowfrog.net/?q=taxonomy/term/41
--
Sonia Hamilton. GPG key A8B77238.
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
