I think the spaces are used as delimiters only for keywords within the text value
On May 31, 2013, at 11:24 AM, "Mark Hansen" <[email protected]<mailto:[email protected]>> wrote: text values have spaces, which get treated as delimiters On Fri, May 31, 2013 at 2:16 PM, Enns, Steven <[email protected]<mailto:[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]<mailto:[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<tel:212-961-7250> cell: 914-924-3398<tel:914-924-3398> http://digitalbrandmine.com/ | email: [email protected]<mailto:[email protected]> _______________________________________________ FastBit-users mailing list [email protected]<mailto:[email protected]> https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users _______________________________________________ FastBit-users mailing list [email protected]<mailto:[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]<mailto:[email protected]> _______________________________________________ FastBit-users mailing list [email protected]<mailto:[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
