Jumping to next line with fscanf()

Question

I have two files .csv and I need to read the whole file but it have to be filed by field. I mean, csv files are files with data separated by comma, so I cant use fgets.
I need to read all the data but I don't know how to jump to the next line.

Here is what I've done so far:

int main()
{
   FILE *arq_file;
   arq_file = fopen("file.csv", "r");

   if(arq_file == NULL){
      printf("Not possible to read the file.");
      exit(0);
   }

   while( !feof(arq_file) ){
   fscanf(arq_file, "%i %lf", &myStruct[i+1].Field1, &myStruct[i+1].Field2);  
   }

   fclose(arq_file);
   return 0;
}  

It will get in a infinity loop because it never gets the next line.
How could I reach the line below the one I just read?

Update: File 01 Example

1,Alan,123,
2,Alan Harper,321
3,Jose Rendeks,32132
4,Maria da graça,822282
5,Charlie Harper,9999999999  

File 02 Example

1,320,123
2,444,321
3,250,123,321
3,3,250,373,451
2,126,621
1,120,320
2,453,1230
3,12345,0432,1830

Answer 1

I think an example is better than giving you hints, this is a combination of fgets() + strtok(), there are other functions that could work for example strchr(), though it's easier this way and since I just wanted to point you in the right direction, well I did it like this

#include <stdio.h>
#include <string.h>
#include <stdlib.h>

int
main(void)
{
    FILE  *file;
    char   buffer[256];
    char  *pointer;
    size_t line;

    file = fopen("data.dat", "r");
    if (file == NULL)
     {
        perror("fopen()");
        return -1;
     }

    line = 0;
    while ((pointer = fgets(buffer, sizeof(buffer), file)) != NULL)
     {
        size_t field;
        char  *token;

        field = 0;
        while ((token = strtok(pointer, ",")) != NULL)
         {
            printf("line %zu, field %zu -> %s\n", line, field, token);

            field  += 1;
            pointer = NULL;
         }
        line += 1;
     }
    return 0;
}

I think it's very clear how the code works and I hope you can understand.

Answer 2

If the same code has to handle both data files, then you're stuck with reading the fields into a string, and subsequently converting the string into a number.

It is not clear from your description whether you need to do something special at the end of line or not — but because only one of the data lines ends with a comma, you do have to allow for fields to be separated by a comma or a newline.

Frankly, you'd probably do OK with using getchar() or equivalent; it is simple.

char buffer[4096];
char *bufend = buffer + sizeof(buffer) - 1;
char *curfld = buffer;
int c;

while ((c = getc(arq_file)) != EOF)
{
    if (curfld == bufend)
        …process overlong field…
    else if (c == ',' || c == '\n')
    {
        *curfld = '\0';
        process(buffer);
        curfld = buffer;
    }
    else
        *curfld++ = c;
}
if (c == EOF && curfld != buffer)
{
    *curfld = '\0';
    process(buffer);
}

However, if you want to go with higher level functions, then you do want to use fgets() to read lines (unless you need to worry about deviant line endings, such as DOS vs Unix vs old-style Mac (CR-only) line endings). Or use POSIX getline() to read arbitrarily long lines. Then split the lines using strtok_r() or equivalent.

char *buffer = 0;
size_t buflen = 0;

while (getline(&buffer, &buflen, arq_file) != -1)
{
     char *posn = buffer;
     char *epos;
     char *token;
     while ((token = strtok_r(posn, ",\n", &epos)) != 0)
     {
         process(token);
         posn = 0;
     }
     /* Do anything special for end of line */
}
free(buffer);

If you think you must use scanf(), then you need to use something like:

char buffer[4096];
char c;

while (fscanf(arq_file, "%4095[^,\n]%c", buffer, &c) == 2)
    process(buffer);

The %4095[^,\n] scan set reads up to 4095 characters that are neither comma nor newline into buffer, and then reads the next character (which must, therefore, either be comma or newline — or conceivably EOF, but that causes problems) into c. If the last character in the file is neither comma nor newline, then you will skip the last field.