I'm seeing the spaces causing the data to be split into different columns with type text.
On Fri, May 31, 2013 at 2:28 PM, Enns, Steven <[email protected]> wrote: > 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]> > wrote: > > 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 > > > _______________________________________________ > 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
