Re: [SLUG] A quick way to remove masses of whitespace from a csv file.

2007-01-29 Thread Martin Visser
On 1/27/07, Steve Kowalik [EMAIL PROTECTED] wrote: Just to throw my 2 cents in, tr(1) can do this. tr -s ' ' oldfile newfile This would nuke *all* of the spaces in the document. Luke clarifed in a follow-up post that it was only whitespace butting up against quotes that needed to be

Re: [SLUG] A quick way to remove masses of whitespace from a csv file.

2007-01-26 Thread Steve Kowalik
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

[SLUG] A quick way to remove masses of whitespace from a csv file.

2007-01-25 Thread Luke Yelavich
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

Re: [SLUG] A quick way to remove masses of whitespace from a csv file.

2007-01-25 Thread Sonia Hamilton
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

Re: [SLUG] A quick way to remove masses of whitespace from a csv file.

2007-01-25 Thread Luke Yelavich
On Fri, Jan 26, 2007 at 09:50:11AM EST, 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

Re: [SLUG] A quick way to remove masses of whitespace from a csv file.

2007-01-25 Thread Alex Samad
On Fri, Jan 26, 2007 at 10:58:09AM +1100, Sonia Hamilton wrote: 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

Re: [SLUG] A quick way to remove masses of whitespace from a csv file.

2007-01-25 Thread Alex Samad
On Fri, Jan 26, 2007 at 11:33:33AM +1100, Luke Yelavich wrote: On Fri, Jan 26, 2007 at 09:50:11AM EST, 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

Re: [SLUG] A quick way to remove masses of whitespace from a csv file.

2007-01-25 Thread Luke Yelavich
On Fri, Jan 26, 2007 at 11:36:10AM EST, Alex Samad wrote: sed -e 's/ +//' oldfile newfile It seems that changing the + to an * did the trick. Thanks. -- Luke Yelavich GPG key: 0xD06320CE (http://www.themuso.com/themuso-gpg-key.txt) Email MSN: [EMAIL PROTECTED] Jabber: [EMAIL

Re: [SLUG] A quick way to remove masses of whitespace from a csv file.

2007-01-25 Thread Alex Samad
On Fri, Jan 26, 2007 at 12:05:06PM +1100, Luke Yelavich wrote: On Fri, Jan 26, 2007 at 11:36:10AM EST, Alex Samad wrote: sed -e 's/ +//' oldfile newfile It seems that changing the + to an * did the trick. Thanks. strange the above should work for test= test and shouldn't do

Re: [SLUG] A quick way to remove masses of whitespace from a csv file.

2007-01-25 Thread Alex Samad
On Fri, Jan 26, 2007 at 12:13:49PM +1100, Alex Samad wrote: On Fri, Jan 26, 2007 at 12:05:06PM +1100, Luke Yelavich wrote: On Fri, Jan 26, 2007 at 11:36:10AM EST, Alex Samad wrote: sed -e 's/ +//' oldfile newfile It seems that changing the + to an * did the trick. Thanks. strange

Re: [SLUG] A quick way to remove masses of whitespace from a csv file.

2007-01-25 Thread Jeff Waugh
quote who=Luke Yelavich I should clarrify my needs a bit. There are text strings in this file that have spaces between words. The whitespace is only at the end of fields, and all text strings have quotes around them. I also think this whitespace is between the last character, and the quote in