Read .CSV file and store it in another file

Question

Have made a program that reads a .csv file and stores the highest number in another file. The problem is that my program can't read comma separated numbers like 1,5,6,7,1,2. Here is the loop I need help to change

int i;
int max = 0;
int min = 0;
while (!feof(fp))
{
    fscanf( fp, "%d", &i);
    if (i < min)
    min = i;
    if (i > max)
    max = i;
}

And this is what I print out:

    fprintf(q,"%d",max);
    printf("maximum value is %d \n", max);
    fclose(q);
    fclose(fp);

[Why is “while ( !feof (file) )” always wrong?](http://stackoverflow.com/questions/5431941/why-is-while-feof-file-always-wrong) — Eugene Sh., May 15 '15 at 14:31
@Mr.T STOP (writing code) !!! Read [this](http://stackoverflow.com/q/5431941/2173917) first. — Sourav Ghosh, May 15 '15 at 14:31
You cannot simply read data from CSV. You have to read an whole line and the parse the numbers between commas. — LPs, May 15 '15 at 14:33
@LPs Not necessarily, but I guess it would be the preferred way. — Eugene Sh., May 15 '15 at 14:35
@Mr.T Check the question and the answer marked in the duplicate. Hope you should get the idea. :-) — Sourav Ghosh, May 15 '15 at 14:37
@EugeneSh. I'm curious: how could you parse CSV file without parse value by value from a string? — LPs, May 15 '15 at 14:37
@LPs By reading char by char until encountering the separator, for example :) — Eugene Sh., May 15 '15 at 14:39
@EugeneSh. Last post, then finish. Is the same thing. I meant that you have to parse values char by char. Bye — LPs, May 15 '15 at 14:41

score 1 · Accepted Answer · answered May 15 '15 at 15:01

#include <stdio.h>
#include <limits.h>

int main(void){
    FILE *fp = fopen("input.csv", "r");
    FILE *q  = fopen("max.txt" , "w");

    int i;
    int max = INT_MIN;
    int min = INT_MAX;

    while(1){
        int state = fscanf(fp, "%d", &i);
        if(state == 1){
            if (i < min)
                min = i;
            if (i > max)
                max = i;
        } else if(state == EOF){
            break;
        } else {
            char ch;
            fscanf(fp, " %c", &ch);
            if(ch != ','){
                fprintf(stderr, "\nformat error\n");
                break;
            }
        }
    }

    fprintf(q, "%d", max);
    printf("maximum value is %d\n", max);
    fclose(q);
    fclose(fp);

    return 0;
}

Read .CSV file and store it in another file

1 Answers1