[wellylug] curly csv formatting

Jamie Baddeley wellylug at vpc.co.nz
Wed Jul 14 22:04:35 NZST 2004


yep. I looked at it and my hair turned ginger!

:-)

jamie

On Wed, 2004-07-14 at 21:55, Ian Beardslee wrote:
> Well I gotta say at the moment that looks all gobbledy gook to me :-)
> 
> 
> -----Original Message-----
> From: jumbophut <jumbophut at gmail.com>
> To: wellylug at lists.naos.co.nz
> Date: Tue, 13 Jul 2004 00:02:40 +1200
> Subject: Re: [wellylug] curly csv formatting
> 
> > On Mon, 12 Jul 2004 23:34:33 +1200, jumbophut  wrote:
> > > 
> > > I know you've solved the problem by now, but I felt the compelling
> > > need to do this in sed.  Why?  Well, just because sed is cool.
> > > 
> > 
> > Replying to my own post, because it can be done with fewer commands
> > and no jumps:
> > 
> > /^[ \t]*[^,]\+,/ {p; s/^[
> > \t]*\([^,]\+\),\([^,]\+\),\([^,]\+\),\(.*\)$/\1,\2,\3/; h; }
> > /^[ \t]*,[ \t]*,/ {s/^[ \t]*,[ \t]*,[ \t]*\(,.*\)$/\1/; H; x; s/\n//;
> > p; }
> > 
> > Should have thought of that on the first go!  Not quite as
> > aesthetically pleasing though.
> > 
> > (Same as last time - save to /tmp/sed2 and run using sed -n
> > --file=/tmp/sed2 datafile).
> > 
> > Tony
> > 
> > 
> > -- 
> > Wellington Linux Users Group Mailing List: wellylug at lists.naos.co.nz
> > To Leave:  http://lists.naos.co.nz/mailman/listinfo/wellylug
> 
> 




More information about the wellylug mailing list