Bob, I am curious. What is your export supposed to look like if one or more of the exported fields contain a comma in the raw data? My understanding is that the data should be quoted (singe or double quotes) if field contains a comma. Or perhaps the big box stores fields prohibit commas.
Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 > >From: "[email protected]" <[email protected]> >To: RBASE-L Mailing List <[email protected]> >Sent: Wed, March 30, 2011 10:08:54 AM >Subject: [RBASE-L] - Re: CSV and Null unload question > >Bob: I'm going to keep your solution in my notes! > >Karen > > > > >Close! However double quotes popped up using the CSV option. >> >>Example using the Gateway Export CSV with Blank_if_zero on >> >> >> >>"IN","661","No",100,,,,,,"$28.39",,,,,,,"100016842","THEHOMEDEPOT", >> >> >> >>However, I was able to get it to work using >> >>Gateway Export TAB with Blank_if_zero and SEPARATOR , options. >> >> >> >>IN,661,No,100,,,,,,$28.39,,,,,,,100016842,THEHOMEDEPOT, >> >> >> >> >> >>This big box store is very particular and the format has to be exactly as >>they >> >>dictate. A pure comma separated file with no quotes, no null characters, etc. >> >> >> >>Thanks for the input, >> >>-Bob >> >> >> >> >> >>
