use sqlite3

const char* delimiters = "@N@ID@B@"
FILE *file = fopen("data.dat","r");
char buff[1024];

fread(&buff,0,sizeof(buff),file);

char *token = strtok(buff,delimiters);

whille(token != 0)
{
token = strtok (NULL,delimiters);

// do what you want with the names, ID and Balance here.....

}

free(&token); // 
    

**** my database.txt

ID, First Name, Second Name, Age, Color
1,John, Smith, 32, Blue
2,Martha, James, 45, Red
3,David,,45,Green   //No Last name
    

Code:

ID, First Name, Second Name, Age, Color     

Now when tokenizing, you must look about for whitespaces (i.e. space, tabs)

#include <windows.h> //blah !!!!!!!.... I just happened to have been using it

#include <stdio.h>

/**
Check if the string is full of integers or char
**/
int isName(char* string)
{
int len = strlen(string);

     for(int i=0;i<len;i++)
   {
      if( string[i]>='A' || string[i]>='a' && 
          string[i]<='Z' || string[i]>='z'
         ){ return 1; 
           }else
          {
              return 0;
           }
      }
}

int isID( char* s_id)
{
if( strlen(s_id) == 8 ){return 1; }else{return 0;}
}

int main(int argc, char *argv[])
{
    FILE *file;
   file = fopen("data.txt","r");
    char buff[1024];

    fread(&buff,1,sizeof(buff),file);
   char* tok = strtok(buff,"@N@ID@B@");

  while(tok!=0){

             if(isName(tok) ) 
                   { 
                 printf("Name: %s\t",tok);
                    }else if (isID(tok)){
                 printf("ID: %d\t",atoi(tok));
                        }else{
     printf(" Balance : $%g",strtod(tok,NULL));
           if( strtod(tok,NULL)<0 )
                 {
                      printf("\t(Overdrawn!)\n");
                     }
                      else
                        {
                      printf("\n");
                    }
              }

          tok = strtok(NULL,"@N@ID@B@");
  }
        printf("\n=================\n");
        fclose(file);
       free(&buff);
    

    return 0;
}



    

int id, age;
char first_name[50], second_name[50], color[50];
if (5 != fscanf(" %d , %s , %s , %d , %s", &id, first_name, second_name, &age, color)) {
  // error
}
    

while (!feof(ptr)) {
    fscanf(" %d , %s , %s , %d , %s", &id, first_name, second_name, &age, color))
}