input data from file into matrix?

[cuizy]

hi......I'm terribly new to programming and have been trying to figure out the proper command to no avail. My input data is something like the following:
apple bee c .....
1.2 2.3 0 .....
2.4 3.5 3.2 ....
.... ..... .....
So the first line are strings that are 'labels' for the columns of numerical data which I want to store in an array. The numerical data I want to store in an matrix. One of my problems is that before opening the file I don't know how many rows or columns the data will have.
This is all I've come up with at the moment. I think I need to use fscanf somehow......but have been very confused by how to use that. Thanks in advance for any help.

  FILE *file; 
  file = fopen("data/hello.txt", "r");
  if(file==NULL) {
    printf("Error: can't open file.\n");
    return 1;
  }
  else {
    printf("File opened. Now read file\n"); 

      //read first line as string and process to count number of columns, then read all the lines
        following that to get number of rows of the data until eof
      //use malloc to create matrix of double of size row x column (I have a function for this elsewhere)
      //start at the beginning of the file and loop through to read each line and somehow store into array[row][col]
  fclose(file);

I apologize in advance for my poor attempt at writing the code for this part. If anybody could help at all with how to read in a line and store the value into an array that would be greatly appreciated.

[Adak]

There will be one column of numbers for each string?

This is not code, it's just ideas for code!

char buff[BUFFSIZE];
int col_num = 0, r, c;
int **A;

fgets(buff, "%s", BUFFSIZE - 1; fileptr);

while(ok = (sscanf(buff, "%s", &garbage)) > 0) {
  col_num++;
}

Now col_num should have your number of columns. Usually, it's no problem figuring out the column number, because the data itself will be ordered by rows, so when you are reading in the data, and you hit a newline char, then you know that's how many columns there are for that row.

Longest row, wins! (tells you how many columns there has to be in your matrix).

More ramblings:

You can use fgets to count your rows up, but save your column headers separately, so you'll have them, for later.

Once you know the # of rows and columns:

*A = malloc your outer row of pointers for A sizeof(int *) 

A = malloc your inner column of integers for A using sizeof(int) this time

and read it into your array:

for(r = 0; r < rows; r++)
   for(c = 0; c < cols; c++) 
       fscanf(fileptr, "%d", &A[r][c]);

Now you can get the column headers still in buff, (again with sscanf(), and print them, then print up a line of =========, and then start with your rows and cols of data, in a very similar way to how they were fscanf()'d from the file, above.



All the above is NOT code, it's just thinking aloud some thoughts in pseudo codish stuff, to give you some idea's.