Re: [sqlite] csv files with unquoted data containing comma's

[Frank van Vugt]

Ken / Dennis,

> My version of output_Csv (3.5.4)  is missing conditional check.
> static void output_csv(struct callback_data *p, const char *z, int bSep){
>   FILE *out = p->out;
>   if( z==0 ){
>     fprintf(out,"%s",p->nullvalue);
>   }else{
>     int i;
>     for(i=0; z[i]; i++){
>       if( needCsvQuote[((unsigned char*)z)[i]] ){
>         i = 0;
>         break;
>       }
>     }

Yep, as stated earlier, that's the same version I'm using here and I'm also 
looking at:

    for(i=0; z[i]; i++){
      if( needCsvQuote[((unsigned char*)z)[i]] ){
        i = 0;
        break;
      }

> Maybe your runtime library id different than the source code?


It seems this got fixed here:
http://www.sqlite.org/cvstrac/filediff?f=sqlite/src/shell.c&v1=1.170&v2=1.171


Looks like a done deal, will try this patch instead.




-- 
Best,




Frank.

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------