Ad:

C Discussion Thread
Unsolved
Views: 9471

Page 1
2
3
4
Next

You are currently viewing page 1 of this multi-page discussion thread

Nov 26th, 2006

How to select data frm text file based on a condition

Expand Post »

My txt file is of the format:

Date Station Operator Task Action

and a list of values under each heading.. Now how do i write a C code to pull up records tht match a specific value under "TASK"...... say for example, if Task = Vendor Setup, then the result shld show me all the records whr task was equal to vendor setup...

Thanx in advance !!!!

nirmala.s

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

18 posts
since Nov 2006

Permalink

Nov 26th, 2006

Re: How to select data frm text file based on a condition

show a couple sample file entries. what you posted tells us very little. But basically you have to read each line of the file and check the task column. there is no one way to do it, so you have to know what the file really looks like.

Ancient Dragon

Sponsor

Team Colleague

Featured Poster

Reputation Points: 5608

Solved Threads: 2282

Retired and Enjoying Life

Offline

21,957 posts
since Aug 2005

Permalink

Nov 26th, 2006

Re: How to select data frm text file based on a condition

Sample entries wud be like :

Date Station Operator Task Action
12-08-2006 TOSHIBA-2F3B7FF TS TS Start TS-Main

12-08-2006 TOSHIBA-2F3B7FF TS TS End TS-Main
16-08-2006 TOSHIBA-2F3B7FF TS Vendor Setup Open Data Folder

Here i need to pull up records whr Task = Vendor Setup.... Cud anyone help me out plz.......

nirmala.s

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

18 posts
since Nov 2006

Permalink

Nov 26th, 2006

Re: How to select data frm text file based on a condition

you can use ifstream's extraction >> operator to get each of the first two strings, then call getline() to get the remainder of the line into a single string. Then just check the last string for what you want

C Syntax (Toggle Plain Text)
std::string date;
std::string operator;
std::string ts;
 
in >> date >> operator;
getline(in,ts);
 
if( ts.find("Vendor Setup") != string::npos)
{
   // text was found
}
std::string date;
std::string operator;
std::string ts;

in >> date >> operator;
getline(in,ts);

if( ts.find("Vendor Setup") != string::npos)
{
   // text was found
}

Of course you will have to put all the above in a loop so as to read the whole file.

Last edited by Ancient Dragon; Nov 26th, 2006 at 11:10 pm.

Ancient Dragon

Sponsor

Team Colleague

Featured Poster

Reputation Points: 5608

Solved Threads: 2282

Retired and Enjoying Life

Offline

21,957 posts
since Aug 2005

Permalink

Nov 26th, 2006

Re: How to select data frm text file based on a condition

Thnx.. but then when it finds few records tht match Task = Vendor Setup, then it shld print out the date and operator of those corresponding records..... How do i do diz... am sorry I'm a beginner in C, so bugging u too much.....

nirmala.s

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

18 posts
since Nov 2006

Permalink

Nov 26th, 2006

Re: How to select data frm text file based on a condition

Here's the code which i wrote but it gave me a whole bunch of errors.. Plz cud u help me out with this....

c Syntax (Toggle Plain Text)
 
# include <stdio.h>
# include <stdlib.h>
# include <string.h>
 
int main()
{
  FILE *in_file;
  char dataFile[20];
 
  printf("Ënter file name");
  scanf ("%s", dataFile);
 
  in_file = fopen(dataFile, "r");
 
  std :: string date;
  std :: string operator;
  std :: string task;
 
  in >> date >> operator;
  getline(in,task);
 
  if (task.find("Vendor Setup") != string::npos)
 
   {
      printf("Data found");
   }
 
   return 0;
}
# include <stdio.h>
# include <stdlib.h>
# include <string.h>

int main()
{
  FILE *in_file;
  char dataFile[20];

  printf("Ënter file name");
  scanf ("%s", dataFile);

  in_file = fopen(dataFile, "r");

  std :: string date;
  std :: string operator;
  std :: string task;

  in >> date >> operator;
  getline(in,task);

  if (task.find("Vendor Setup") != string::npos)
  
   {
      printf("Data found");
   }
  
   return 0;
}

The following are the errors which were listed when I compiled the code:

filterdaa.c
filterdaa.c(15) : error C2143: syntax error : missing ';' before ':'
filterdaa.c(16) : error C2143: syntax error : missing ';' before ':'
filterdaa.c(17) : error C2143: syntax error : missing ';' before ':'
filterdaa.c(19) : error C2065: 'in' : undeclared identifier
filterdaa.c(19) : error C2065: 'date' : undeclared identifier
filterdaa.c(19) : error C2065: 'operator' : undeclared identifier
filterdaa.c(19) : warning C4552: '>>' : operator has no effect; expected operato
r with side-effect
filterdaa.c(20) : error C2065: 'task' : undeclared identifier
filterdaa.c(22) : error C2224: left of '.find' must have struct/union type
filterdaa.c(22) : error C2065: 'string' : undeclared identifier
filterdaa.c(22) : error C2143: syntax error : missing ')' before ':'
filterdaa.c(22) : error C2059: syntax error : ')'
filterdaa.c(28) : error C2059: syntax error : 'return'
filterdaa.c(29) : error C2059: syntax error : '}'

I've no clue now as to wht has 2 be done..plz help me out...

nirmala.s

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

18 posts
since Nov 2006

Permalink

Nov 26th, 2006

Re: How to select data frm text file based on a condition

C Syntax (Toggle Plain Text)
std :: string date;
std :: string operator;
std :: string task;
std :: string date;
std :: string operator;
std :: string task;

I think you forgot to include iostream before using these -- they're part of the Standard Template Library.

Hmm... here you never declared in, which should be of type ifstream:

C Syntax (Toggle Plain Text)

in >> date >> operator;

Also, I think you should scrap fopen(), as using Mr. Dragon's suggestions, you have no need for the C functions to open files. Simply declare something like

C Syntax (Toggle Plain Text)
ifstream in("file.txt");
ifstream in("file.txt");

That takes care of opening the file, and then you won't get errors.

Hope this helps

John A

Team Colleague

Reputation Points: 2240

Solved Threads: 338

Vampirical Lurker

Offline

5,055 posts
since Apr 2006

Permalink

Nov 26th, 2006

Re: How to select data frm text file based on a condition

Oh, I see you are writing a C program, not a c++ program. What I posted will not work. You will have to use character arrays instead of those c++ string classes.

Read you text book about printf() function to find out how to print something on the screen. I would like to give you the complete solution to your assignment, but if I did that you would not learn a thing. Programming is very time consuming, not like just reading a novel.

I did not compile this, and hopefully it does not contain too many errors.

C Syntax (Toggle Plain Text)
# include <stdio.h>
# include <stdlib.h>
# include <string.h>
 
int main()
{
  FILE *in_file;
  char dataFile[20];
  char date[20];
  char operator[30];
  char ts[80];
 
  printf("Ënter file name");
  scanf ("%s", dataFile);
 
  in_file = fopen(dataFile, "r");
 
  fsprintf(in_file,"%s %s", date, operator);
  fgets(ts,sizeof(ts), in_file);
 
 
  if ( strstr(ts,"Vendor Setup" != NULL)
 
   {
      printf("Data found");
   }
 
   return 0;
}
# include <stdio.h>
# include <stdlib.h>
# include <string.h>
 
int main()
{
  FILE *in_file;
  char dataFile[20];
  char date[20];
  char operator[30];
  char ts[80];
 
  printf("Ënter file name");
  scanf ("%s", dataFile);
 
  in_file = fopen(dataFile, "r");
 
  fsprintf(in_file,"%s %s", date, operator);
  fgets(ts,sizeof(ts), in_file);
 
 
  if ( strstr(ts,"Vendor Setup" != NULL)
  
   {
      printf("Data found");
   }
  
   return 0;
}

Last edited by Ancient Dragon; Nov 26th, 2006 at 11:57 pm.

Ancient Dragon

Sponsor

Team Colleague

Featured Poster

Reputation Points: 5608

Solved Threads: 2282

Retired and Enjoying Life

Offline

21,957 posts
since Aug 2005

Permalink

Nov 27th, 2006

Re: How to select data frm text file based on a condition

Thnx Joe... I followed ur suggestions, the errors ve all disappeared but the thing is "how do i include iostream" ???? is it a header file... am very sorry, diz mite sound silly but then i seriously dunno much abt C..am just learnin it now by practice..

Now i got the error:

Fatal Error: C1083 : Cannot open include file - iostream.h

nirmala.s

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

18 posts
since Nov 2006

Permalink

Nov 27th, 2006

Re: How to select data frm text file based on a condition

Click to Expand / Collapse Quote originally posted by nirmala.s ...

Thnx Joe... I followed ur suggestions, the errors ve all disappeared but the thing is "how do i include iostream" ???? is it a header file... am very sorry, diz mite sound silly but then i seriously dunno much abt C..am just learnin it now by practice..

Now i got the error:

Fatal Error: C1083 : Cannot open include file - iostream.h

Confusion abounds -- are you writing a C or a C++ program??????? The code Joe posted and the code I originally posted is C++, not C. They are two different languages, and you must know which you want before you can write your program.

iostream.h is an obsolete file. use the header file without the .h extension. For c++ programs only

C Syntax (Toggle Plain Text)

#include <iostream>

Last edited by Ancient Dragon; Nov 27th, 2006 at 12:10 am.

Ancient Dragon

Sponsor

Team Colleague

Featured Poster

Reputation Points: 5608

Solved Threads: 2282

Retired and Enjoying Life

Offline

21,957 posts
since Aug 2005

Page 1
2
3
4
Next

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in C Forum Timeline: Using a laser printer with C

Next Thread in C Forum Timeline: c home work

DaniWeb Message

Cancel Changes

User Name
Password