Thread: help with reading a data file

First off how would i write this into a datafile (i guess a text file) so i can build a cprogram and read this information?
Like this?
ID1
customer_number 10
gallons_consumed 500
EndID

|----- snip -----|
(i save the following information as datafile.txt - im guessing the above is completely incorrect, so i could use assistance on writing a datafile, please)

The above would work splendidly. You need to do the following:

1) Read the ID number line, this denotes the start of a 'record'.
2) Read the customer_number line.
3) Read the gallons_consumed line.
4) Read the EndID line.

Personally, I've used a similar method before for a not entirely different tastk. I prefer something like this:

Code:

/*
    Add your own error checking. I am
    assuming that the file pointer has
    been opened correctly for the sake
    of the example, and I'm assuming
    you want the record returned in a
    structure of some kind.
*/
struct myRecord * myFun( FILE * fp )
{
    char buf[BUFSIZ]={0};
    struct myRecord * recNew = NULL;
    int done = 0;

    while( fgets( buf, BUFSIZ, fp ) != NULL && !done )
    {
        switch( buf[0] )
        { 
            case 'I':
                if( !strncmp( buf, "ID1", 3 ) )
                {
                    if( recNew == NULL )
                        recNew = malloc( sizeof( struct myRecord ) );
                    else
                        /*error, do somehting*/
                }
            break;
            case 'c':
                if( !strncmp( buf, "customer_number", 15 ) )
                {
                    /*
                        pull the number from
                        the end of the string
                        and stick it in the node
                    */
                }
            break;
            case 'g':
                if( !strncmp( buf, "gallons_consumed", 16 ) )
                {
                    /*
                        pull the number from
                        the end of the string
                        and stick it in the node
                    */                }
            break;
            case 'E':
                if( !strcmp( buf, "EndID" ) )
                {
                    done = 1;
                }
            break;
            default:
                /* You have invalid data. */
        }
    }
    return recNew;
}

A lengthy example. I kept it as short as I could. You may see some functions you are unfamiliar with, so just go here to read up on them. Not all the functions at this link are ANSI, but they'll tell you if they aren't.

Now on to part two:

Next im wondering if this is the correct way to open/read the datafile within my c program:

Yes. You've opened the file correctly. You can use 'fgets' like I did in the above example to read a line from a text file. See the provided link in the event you aren't sure how it works.

I used a structure to contain the data. I find this best in this situation. However, if you're just tallying them up, you may want to just use sscanf once you have read a line to read the buffer and pull the chunk out that you need. If you do this, you won't need a seperate function to read the data.

The reason I use the format I have above is because it will safely read a file until it hits the end of it, or until it encounters the end of a record. It also allows for you to discard unwanted lines. You could add a bit more to it and make it ensure safe handling or logging of duplicate lines. IE:

ID1
customer_record x
customer_record y
gallons_consumed z
EndID

I actually prefer binary files because you can read and write entire records in one shot and have the data go directly into your structures. However, if you need to use text so you can manually edit it, the above solution should suffice.

[edit]
As I was typing this novel, Salem beat me to it...
[/edit]


Quzah.

Thanks for the tips! I appreciate it! Some of it was alittle too far advanced for me, but i was able achieve some progress im almost finished i think.

I changed my datafile, hopefully to simplify the procedure - i only put two columns of numbers. Column #1 = customer_number and Column #2 = gallons_used.

Example datafile.txt:
10 50
22 20
70 800
100 400
250 60

I used your advise and went with fgets() & sscanf(). I also put in a counter which allowed me to print out the total number of customers.

Code:

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

int main()
{
   int customer_number, gallons_used, amount_due;
   int CustomerCount = 0;
   char str[255];
   FILE *fpr = fopen("datafile.txt", "rt");
   
   if( fpr == NULL )
       return 1;
   
   printf("Customer Number\t\tWater Usage\t\tAmount Due\n");
   while( feof( fpr ) == 0 )
   {
       fgets(str, sizeof(str), fpr);	
       if(sscanf( str, "%d %d", &customer_number, &gallons_used) != 2)
           break;
       CustomerCount++;	
       printf("%d\t\t\t%d\n", customer_number, gallons_used);	
   }
   fclose(fpr);
   printf("\nThere are %d customers.\n", CustomerCount);

   return 0;
}

and that produces an output of:

Code:

Customer Number         Water Usage             Amount Due
10                                  50
22                                  20
70                                  800
100                                400
250                                60

There are 5 customers.

Now i only need to accomplish three more objectives.
#1) How do i add the numbers in column two, so that i can figure out the total amount of consumed water.
#2) How do i take the data from column two and multiply it by a set price? So i can find the Amount Due for each costomer. For example lets say i now charged:
Water consumed 000 to 100 gallons = $0.10 per each gallon.
Water consumed 101 to 200 gallons = $0.20 per each gallon.
Water consumed 201 to 999 gallons = $0.30 per each gallon.
I know i would need a simple loop kinda like this:
if (gallons_used >= 999)
charge = .30
else if (gallons_used >= 200)
charge = .20
else (gallons_used >= 100)
charge = .10
But I dont know how to point towards column twos gallons used information. And i dont where or how i would put this code.
#3) Once i figure out each customers amount due, i need to find the total amount due from all the customers - in other words find a way to add up all everything in column 3 (amount due). Basically repeating objective number 1.

Also do i need to change the datafile.txt back to where i had it before or will the simplied version work fine too? Thanks for any help!!