Thanks - that worked. Now it looks like I have some " characters in my strings as well. Can I escape these somehow?
On Fri, May 31, 2013 at 3:21 PM, Enns, Steven <[email protected]> wrote: > Ah I see – you need to specify comma as the delimiter using the -b flag, > otherwise it includes space as the delimiter > > > From: Mark Hansen <[email protected]> > Reply-To: FastBit Users <[email protected]> > Date: Friday, May 31, 2013 11:35 AM > To: FastBit Users <[email protected]> > Subject: Re: [FastBit-users] CSV structure for loading > > 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 > > -- 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
