On Fri, 26 Jan 2007 09:50:11 +1100, Luke Yelavich uttered
> 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.
>
Just to throw my 2 cents in, tr(1) can do this.
tr -s ' ' < oldfile > newfile
Cheers,
--
Steve
"I'm a doctor, not a doorstop"
- EMH, USS Enterprise
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
