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 > > > > > >
