text values have spaces, which get treated as delimiters
On Fri, May 31, 2013 at 2:16 PM, Enns, Steven <[email protected]> wrote: > As long as there are no delimiters (comma or newline) in your text > values, you could just remove the quotes > sed -e 's/"//g' > > > On May 31, 2013, at 11:09 AM, "Mark Hansen" <[email protected]> > wrote: > > The CSV files that I need to load have quotes around the values - both > numeric and text values. When I load using ardea, I get a mess. I need > quotes on the text columns because there are spaces in the text values. > > What should I do? > > Here is a sample of the CSV data: > > "89493","1407","2012-12-14","(not set)","linda > farrow","33","35","26","166","143","13641","8" > "89494","1407","2012-12-14","(not set)","linda farrow > brillen","1","3","0","3","3","0","3" > "89495","1407","2012-12-14","(not set)","linda farrow > vintage","1","1","0","1","1","0","1" > "89496","1407","2012-12-14","(not set)","óculos linda > farrow","1","1","1","11","8","816","0" > "89497","1407","2012-12-13","(not set)","(not > set)","83","98","75","561","420","45517","28" > "89498","1407","2012-12-13","(not set)","(not > provided)","36","42","31","219","172","15951","5" > > > -- > Mark Hansen > Founder & President > Digital Brand Mine | 708 3rd Ave | New York, New York 10017 > office: 212-961-7250 > cell: 914-924-3398 > http://digitalbrandmine.com/ | email: [email protected] > > _______________________________________________ > > FastBit-users mailing list > [email protected] > https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users > > > _______________________________________________ > FastBit-users mailing list > [email protected] > https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users > > -- Mark Hansen Founder & President Digital Brand Mine | 708 3rd Ave | New York, New York 10017 office: 212-961-7250 cell: 914-924-3398 http://digitalbrandmine.com/ | email: [email protected]
_______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
