CSV read error

[pcrana]

while reading a csv file using following code, abnormal operation error comes:

int main(void)
{
   const char filename[] = "d:\\tc\\csv1.csv";
   FILE *file = fopen(filename, "r");
       char scname[11];
     char sctype[3];
     double oval;
     double hval;
     double lval;
     double lclos;
     double qty;
     double idno;
     char tdate[11];
     int j;
//csv1.csv file has 9 fields as above
 clrscr();
 while(fscanf(file,"%10s %2s %f %f %f %f %f %f %10s",scname,sctype,&oval,&hval,&lval,&lclos,&qty,&idno,tdate) != EOF)
  {
    printf("%10s %2s %f %f %f %f %f %f %10s\n",scname,sctype,oval,hval,lval,lclos,qty,idno,tdate);
  }
fclose(file);
return 0;
}

i have tried %s, %e specifiers in fscanf;
if i use %s then whole line is stored in first field viz. scname;

is this the correct way to read csv file?
i want to associate each field of each line in csv with the variables used above.
thanks for your valuable replies in advance

[CommonTater]

 while(fscanf(file,"%10s,%2s,%f,%f,%f,%f,%f,%f,%10s",scname,sctype,&oval,&hval,&lval,&lclos,&qty,&idno,tdate) > 8)

It's pattern matching... in this case the pattern is values separated by comas...

Look up fscanf() in your C library documentation for why >8 instead of EOF.

[pcrana]

control does not enter inside the loop with fscanf > 8 condition.

with != EOF, the error that comes is "floating point error:domain. abnormal program termination"

[MK27]

Well, you should check what it is if it is <8, because there are 9 specifiers there.

The reason you get the error with != EOF is probably because if the return value is >=0 you do enter the loop.

I notice there are no commas in your template, but you refer to csv data.

if i use %s then whole line is stored in first field viz. scname;

That would happen if there is no whitespace, because it is csv data ("bob,32,alpha,32.4,11" is one %s). You could use:

fscanf("%[^,],%[^,],%f" etc

[] is a set stored in a char*. ^ means "not", so %[^,] will grab anything upto a comma.

[CommonTater]

control does not enter inside the loop with fscanf > 8 condition.

with != EOF, the error that comes is "floating point error:domain. abnormal program termination"

If your variables are doubles, you need to use %lf not %f ... That's most likely the biggest problem right now.

[rags_to_riches]

Does Turbo C support %lf? Because judging by this line

const char filename[] = "d:\\tc\\csv1.csv";

I'm betting the "tc" part of that is Turbo C.

[CommonTater]

Does Turbo C support %lf? Because judging by this line

const char filename[] = "d:\\tc\\csv1.csv";

I'm betting the "tc" part of that is Turbo C.

Good question... the 16 bit versions did not... don't know about the TC++ versions.

In any event, our OP friend might just want to consider an upgrade to something from this millenium.

[pcrana]

thanks to all for replies.
got the solution using [^,]
and also changing double to float and %f in conversion specifier solved the problem
thanks once again

[iMalc]

None of this is the right way to parse a CSV file. A csv file is allowed to have double-quotes around the data in a column, and that string data is allowed to contain commas. There is no valid way to parse in a generic CSV file by matching it against a predefined pattern.
You need to process the incomming data character by character within a state machine that takes care of commas embedded within a column etc.
Have a good read of Comma-separated values - Wikipedia, the free encyclopedia