Help – file reading

[Ernesto0751]

hi,

can someone give me the idea on how to read the following file (student’s mark text file) using array and then print it out, how would be the design of the code?

No Matrix quiz1(5%) quiz1(5%) quiz1(5%) Proj(25%) MidT
1 BK20008 4 3 5 18 18
2 BK20002 5 5 4 10 8
3 BK20003 3 4 5 18 10
4 BK20006 4 3 4 20 14
5 BK20005 5 4 3 13 17
6 BK20004 2 5 2 4 16
7 BK20007 3 4 4 21 14
8 BK20001 4 3 5 11 15
9 BK20009 3 2 4 10 10
10 BK20010 4 3 3 23 18

i’m not asking for code because this is my project. After reading the file, the program have to calculate the grade and sort them, but first i have to know how to read this file

any kindly help i will be very appreciate!
thanks in advance

[JonathaThurston]

Are you using C or C++? If its C the following can help.

<br /> fscanf(fileName, "%d [] %d %d %d %d %d", variableName, arrayName, variableName ...);<br />

1 2 3

<br /> fscanf(fileName, "%d [] %d %d %d %d %d", variableName, arrayName, variableName ...);<br />

[Ernesto0751]

int main ()<br /> {<br /> char matrix[20][200];<br /> int i, j, no[20], quiz_1[20], quiz_2[20], quiz_3[20], project[20], midT[20];<br /> FILE *infile;<br /> <br /> infile = fopen("studentsmark.txt","r");<br /> <br /> i=0;<br /> <br /> while( fscanf(infile,"%d %s %d %d %d %d %d",&#038;no<i>, matrix</i><i>, &#038;quiz_1</i><i>, &#038;quiz_2</i><i>, &#038;quiz_3</i><i>, &#038;project</i><i>, &#038;midT</i><i>) !=EOF) i++;<br /> <br /> <br /> <br /> for(j=0;j<i;j++)<br /> {<br /> printf("%d %s %d %d %d %d %dn",no[j], matrix[j], quiz_1[j], quiz_2[j], quiz_3[j], project[j], midT[j]);<br /> }<br /> <br /> fclose(infile);<br /> }#include <stdio.h><br /> <br /> <br /> int main ()<br /> {<br /> char matrix[20][200];<br /> int i, j, no[20], quiz_1[20], quiz_2[20], quiz_3[20], project[20], midT[20];<br /> FILE *infile;<br /> <br /> infile = fopen("studentsmark.txt","r");<br /> <br /> i=0;<br /> <br /> while( fscanf(infile,"%d %s %d %d %d %d %d",&#038;no</i><i>, matrix</i><i>, &#038;quiz_1</i><i>, &#038;quiz_2</i><i>, &#038;quiz_3</i><i>, &#038;project</i><i>, &#038;midT</i><i>) !=EOF) i++;<br /> <br /> <br /> <br /> for(j=0;j<i;j++)<br /> {<br /> printf("%d %s %d %d %d %d %dn",no[j], matrix[j], quiz_1[j], quiz_2[j], quiz_3[j], project[j], midT[j]);<br /> }<br /> <br /> fclose(infile);<br /> }</i>

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44

int main ()<br /> {<br /> char matrix[20][200];<br /> int i, j, no[20], quiz_1[20], quiz_2[20], quiz_3[20], project[20], midT[20];<br /> FILE *infile;<br /> <br /> infile = fopen("studentsmark.txt","r");<br /> <br /> i=0;<br /> <br /> while( fscanf(infile,"%d %s %d %d %d %d %d",&#038;no<i>, matrix</i><i>, &#038;quiz_1</i><i>, &#038;quiz_2</i><i>, &#038;quiz_3</i><i>, &#038;project</i><i>, &#038;midT</i><i>) !=EOF) i++;<br /> <br /> <br /> <br /> for(j=0;j<i;j++)<br /> {<br /> printf("%d %s %d %d %d %d %dn",no[j], matrix[j], quiz_1[j], quiz_2[j], quiz_3[j], project[j], midT[j]);<br /> }<br /> <br /> fclose(infile);<br /> }#include <stdio.h><br /> <br /> <br /> int main ()<br /> {<br /> char matrix[20][200];<br /> int i, j, no[20], quiz_1[20], quiz_2[20], quiz_3[20], project[20], midT[20];<br /> FILE *infile;<br /> <br /> infile = fopen("studentsmark.txt","r");<br /> <br /> i=0;<br /> <br /> while( fscanf(infile,"%d %s %d %d %d %d %d",&#038;no</i><i>, matrix</i><i>, &#038;quiz_1</i><i>, &#038;quiz_2</i><i>, &#038;quiz_3</i><i>, &#038;project</i><i>, &#038;midT</i><i>) !=EOF) i++;<br /> <br /> <br /> <br /> for(j=0;j<i;j++)<br /> {<br /> printf("%d %s %d %d %d %d %dn",no[j], matrix[j], quiz_1[j], quiz_2[j], quiz_3[j], project[j], midT[j]);<br /> }<br /> <br /> fclose(infile);<br /> }</i>

but i am unable to read tis line
No Matrix quiz1(5%) quiz1(5%) quiz1(5%) Proj(25%) MidT(20%)

what should i add to make the program read it and ignore it so it can read on the real data i need, i really have no idea…

[Ernesto0751]

int main ()<br /> {<br /> char matrix[20][200];<br /> int i, j, no[20], quiz_1[20], quiz_2[20], quiz_3[20], project[20], midT[20];<br /> FILE *infile;<br /> <br /> infile = fopen("studentsmark.txt","r");<br /> <br /> i=0;<br /> <br /> while( fscanf(infile,"%d %s %d %d %d %d %d",&#038;no<i>, matrix</i><i>, &#038;quiz_1</i><i>, &#038;quiz_2</i><i>, &#038;quiz_3</i><i>, &#038;project</i><i>, &#038;midT</i><i>) !=EOF) i++;<br /> <br /> <br /> <br /> for(j=0;j<i;j++)<br /> {<br /> printf("%d %s %d %d %d %d %dn",no[j], matrix[j], quiz_1[j], quiz_2[j], quiz_3[j], project[j], midT[j]);<br /> }<br /> <br /> fclose(infile);<br /> }#include <stdio.h><br /> <br /> <br /> int main ()<br /> {<br /> char matrix[20][200];<br /> int i, j, no[20], quiz_1[20], quiz_2[20], quiz_3[20], project[20], midT[20];<br /> FILE *infile;<br /> <br /> infile = fopen("studentsmark.txt","r");<br /> <br /> i=0;<br /> <br /> while( fscanf(infile,"%d %s %d %d %d %d %d",&#038;no</i><i>, matrix</i><i>, &#038;quiz_1</i><i>, &#038;quiz_2</i><i>, &#038;quiz_3</i><i>, &#038;project</i><i>, &#038;midT</i><i>) !=EOF) i++;<br /> <br /> <br /> <br /> for(j=0;j<i;j++)<br /> {<br /> printf("%d %s %d %d %d %d %dn",no[j], matrix[j], quiz_1[j], quiz_2[j], quiz_3[j], project[j], midT[j]);<br /> }<br /> <br /> fclose(infile);<br /> }</i>

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44

int main ()<br /> {<br /> char matrix[20][200];<br /> int i, j, no[20], quiz_1[20], quiz_2[20], quiz_3[20], project[20], midT[20];<br /> FILE *infile;<br /> <br /> infile = fopen("studentsmark.txt","r");<br /> <br /> i=0;<br /> <br /> while( fscanf(infile,"%d %s %d %d %d %d %d",&#038;no<i>, matrix</i><i>, &#038;quiz_1</i><i>, &#038;quiz_2</i><i>, &#038;quiz_3</i><i>, &#038;project</i><i>, &#038;midT</i><i>) !=EOF) i++;<br /> <br /> <br /> <br /> for(j=0;j<i;j++)<br /> {<br /> printf("%d %s %d %d %d %d %dn",no[j], matrix[j], quiz_1[j], quiz_2[j], quiz_3[j], project[j], midT[j]);<br /> }<br /> <br /> fclose(infile);<br /> }#include <stdio.h><br /> <br /> <br /> int main ()<br /> {<br /> char matrix[20][200];<br /> int i, j, no[20], quiz_1[20], quiz_2[20], quiz_3[20], project[20], midT[20];<br /> FILE *infile;<br /> <br /> infile = fopen("studentsmark.txt","r");<br /> <br /> i=0;<br /> <br /> while( fscanf(infile,"%d %s %d %d %d %d %d",&#038;no</i><i>, matrix</i><i>, &#038;quiz_1</i><i>, &#038;quiz_2</i><i>, &#038;quiz_3</i><i>, &#038;project</i><i>, &#038;midT</i><i>) !=EOF) i++;<br /> <br /> <br /> <br /> for(j=0;j<i;j++)<br /> {<br /> printf("%d %s %d %d %d %d %dn",no[j], matrix[j], quiz_1[j], quiz_2[j], quiz_3[j], project[j], midT[j]);<br /> }<br /> <br /> fclose(infile);<br /> }</i>

but i am unable to read tis line
No Matrix quiz1(5%) quiz1(5%) quiz1(5%) Proj(25%) MidT(20%)

what should i add to make the program read it and ignore it so it can read on the real data i need, i really have no idea…

[msaqib]

Use fgets() function to read the file line by line and then split the string and store all the values in variables.

<br /> int x = 0;<br /> while (fgets(msg,25,fp)!=NULL)<br /> {<br /> x++;<br /> if(x==0){<br /> //we do not need to read first line as it contians headings<br /> //this is the first line which you don't need to read and you can hardcode it in progrm<br /> }<br /> else{<br /> //write your rest of the program here to read the data and manipulate<br /> }<br /> <br /> }<br />

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

<br /> int x = 0;<br /> while (fgets(msg,25,fp)!=NULL)<br /> {<br /> x++;<br /> if(x==0){<br /> //we do not need to read first line as it contians headings<br /> //this is the first line which you don't need to read and you can hardcode it in progrm<br /> }<br /> else{<br /> //write your rest of the program here to read the data and manipulate<br /> }<br /> <br /> }<br />

[Ernesto0751]

thanks! i hav been thinking the whole day for this. I will try working on it !

[Ernesto0751]

now my program able to read the file by adding some code given by you, but i couldnt understand how it actually run..

#include <stdio.h><br /> <br /> <br /> void main (void)<br /> {<br /> char matrix[20][200], line[100][100];<br /> int i, j, x, no[20], quiz_1[20], quiz_2[20], quiz_3[20], project[20], midT[20], final[20];<br /> FILE *infile;<br /> <br /> infile = fopen("studentsmark.txt","r");<br /> <br /> x=0;<br /> while (fgets(line,100,infile)!=NULL)<br /> {<br /> <br /> x++;<br /> if(x==1)<br /> {<br /> <br /> }<br /> <br /> else{<br /> i=0;<br /> while( fscanf(infile,"%d %s %d %d %d %d %d %d",&#038;no<i>,matrix</i><i>, &#038;quiz_1</i><i>, &#038;quiz_2</i><i>, &#038;quiz_3</i><i>, &#038;project</i><i>, &#038;midT</i><i>, &#038;final</i><i>) !=EOF)<br /> <br /> <br /> <br /> printf("%d %s %d %d %d %d %d %dn",no</i><i>, matrix</i><i>, quiz_1</i><i>, quiz_2</i><i>, quiz_3</i><i>, project</i><i>, midT</i><i>, final</i><i>);<br /> i++;<br /> <br /> <br /> <br /> <br /> }<br /> <br /> }<br /> fclose(infile);<br /> }</i>

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38

#include <stdio.h><br /> <br /> <br /> void main (void)<br /> {<br /> char matrix[20][200], line[100][100];<br /> int i, j, x, no[20], quiz_1[20], quiz_2[20], quiz_3[20], project[20], midT[20], final[20];<br /> FILE *infile;<br /> <br /> infile = fopen("studentsmark.txt","r");<br /> <br /> x=0;<br /> while (fgets(line,100,infile)!=NULL)<br /> {<br /> <br /> x++;<br /> if(x==1)<br /> {<br /> <br /> }<br /> <br /> else{<br /> i=0;<br /> while( fscanf(infile,"%d %s %d %d %d %d %d %d",&#038;no<i>,matrix</i><i>, &#038;quiz_1</i><i>, &#038;quiz_2</i><i>, &#038;quiz_3</i><i>, &#038;project</i><i>, &#038;midT</i><i>, &#038;final</i><i>) !=EOF)<br /> <br /> <br /> <br /> printf("%d %s %d %d %d %d %d %dn",no</i><i>, matrix</i><i>, quiz_1</i><i>, quiz_2</i><i>, quiz_3</i><i>, project</i><i>, midT</i><i>, final</i><i>);<br /> i++;<br /> <br /> <br /> <br /> <br /> }<br /> <br /> }<br /> fclose(infile);<br /> }</i>

this is my actual input file

123401234567890123456789012345678901234567890123456789012345678901234567890123456789<br /> No Matrix quiz1(5%) quiz1(5%) quiz1(5%) Proj(25%) MidT(20%) Final(40%)<br /> 1 BK20008 4 3 5 18 18 36<br /> 2 BK20002 5 5 4 10 8 30<br /> 3 BK20003 3 4 5 18 10 35<br /> 4 BK20006 4 3 4 20 14 36<br /> 5 BK20005 5 4 3 13 17 28<br /> 6 BK20004 2 5 2 4 16 10<br /> 7 BK20007 3 4 4 21 14 32<br /> 8 BK20001 4 3 5 11 15 31<br /> 9 BK20009 3 2 4 10 10 20<br /> 10 BK20010 4 3 3 23 18 22

1 2 3 4 5 6 7 8 9 10 11 12

123401234567890123456789012345678901234567890123456789012345678901234567890123456789<br /> No   Matrix    quiz1(5%) quiz1(5%) quiz1(5%) Proj(25%) MidT(20%) Final(40%)<br /> 1    BK20008   4         3         5         18        18        36<br /> 2    BK20002   5         5         4         10        8         30<br /> 3    BK20003   3         4         5         18        10        35<br /> 4    BK20006   4         3         4         20        14        36<br /> 5    BK20005   5         4         3         13        17        28<br /> 6    BK20004   2         5         2         4         16        10<br /> 7    BK20007   3         4         4         21        14        32<br /> 8    BK20001   4         3         5         11        15        31<br /> 9    BK20009   3         2         4         10        10        20<br /> 10   BK20010   4         3         3         23        18        22

there is a line of number in the input file.can you explain to me? thanks!

[msaqib]

The code

while (fgets(line,100,infile)!=NULL)

1	while (fgets(line,100,infile)!=NULL)

reads the file and function fgets() reads the file line by line. So when the program reads first line, it skips the first line of records which is
No Matrix quiz1(5%) quiz1(5%) quiz1(5%) Proj(25%) MidT(20%) Final(40%)
and is done by this code:

if(x==1)<br /> {<br /> <br /> }

1 2 3 4

if(x==1)<br /> {<br /> <br /> }

And you read all the marks and data in else part of the program.

else{<br /> i=0;<br /> while( fscanf(infile,"%d %s %d %d %d %d %d %d",&#038;no<i>,matrix</i><i>, &#038;quiz_1</i><i>, &#038;quiz_2</i><i>, &#038;quiz_3</i><i>, &#038;project</i><i>, &#038;midT</i><i>, &#038;final</i><i>) !=EOF)<br /> printf("%d %s %d %d %d %d %d %dn",no</i><i>, matrix</i><i>, quiz_1</i><i>, quiz_2</i><i>, quiz_3</i><i>, project</i><i>, midT</i><i>, final</i><i>);<br /> i++;<br /> }</i>

1 2 3 4 5 6

else{<br /> i=0;<br /> while( fscanf(infile,"%d %s %d %d %d %d %d %d",&#038;no<i>,matrix</i><i>, &#038;quiz_1</i><i>, &#038;quiz_2</i><i>, &#038;quiz_3</i><i>, &#038;project</i><i>, &#038;midT</i><i>, &#038;final</i><i>) !=EOF)<br /> printf("%d %s %d %d %d %d %d %dn",no</i><i>, matrix</i><i>, quiz_1</i><i>, quiz_2</i><i>, quiz_3</i><i>, project</i><i>, midT</i><i>, final</i><i>);<br /> i++;<br /> }</i>

[Author]

Posts