Re: [Haskell-cafe] Re: Sneaking haskell in the workplace -- cleaning csv files

On Jun 17, 2007, at 14:04 , Pete Kazmier wrote:

"Brandon S. Allbery KF8NH" writes:

...

On Jun 15, 2007, at 18:37 , Jason Dagit wrote:

...

I love to see people using Haskell, especially professionally, but I have to wonder if the real tool for this job is sed? :-)

Actually, while sed could do that, it'd be a nightmare. You really want a parser to deal with general CSV like this, and while you can write parsers in sed, you *really* don't want to. :)

sed ':a /,$/!{N;s/\n//;ba}' somefile.csv

If it's simple enough, sure. If you get into dealing with quoting, it gets a lot more complex in a hurry. Of course, given that this is from Oracle, it *probably* doesn't. (But as a sysadmin and ex-dba, "probably" is worrisome....) -- brandon s. allbery [solaris,freebsd,perl,pugs,haskell] allbery@kf8nh.com system administrator [openafs,heimdal,too many hats] allbery@ece.cmu.edu electrical and computer engineering, carnegie mellon university KF8NH