DaniWeb Forum Index > Software Development > C++

C++ RSS

csv problem

•

Join Date: Mar 2007

Posts: 61

Reputation: squinx22 is an unknown quantity at this point

Solved Threads: 0

squinx22

Offline

Junior Poster in Training

csv problem

Mar 29th, 2007

somebody help me pls...
my task is to search a value that matches to my csv file.

my csv file contents is like this:

0,"100","WA"
101,"201","BC"
202,"302","EC"

this should be the scenario.

enter value: 205
output: BC

pls include the codes.. i am just a beginner.. thanks in advance..

•

Join Date: Aug 2005

Posts: 15,151

Reputation: Ancient Dragon has a reputation beyond repute

Solved Threads: 1435

Ancient Dragon Ancient Dragon is offline

Offline

Most Valuable Poster

Re: csv problem

Mar 29th, 2007

In your example if you enter "205" you will get nothing because there are no lines that contain "205"

But I understand what you mean anyway.

>>pls include the codes
Please first post your code to show us the effort you are making to solve the problem.

I would read the file one line at a time using fgets() function. Then you can use either strstr() to see if the line contains the search string, such as "205" and if it exists print the remainder of the line.

Code the problem one small step at a time to help from getting overwhelmed with the assignment. First, write the program that just opens the file. Get that to compile and work correctly. Then add to it the code needed to read each line using fgets(). Once that works you can continue with the reset of the assignment.

Don't PM me with questions -- you might get a nasty PM in response. If you have a question then post it in one of the forums.

•

Join Date: Mar 2007

Posts: 61

Reputation: squinx22 is an unknown quantity at this point

Solved Threads: 0

squinx22

Offline

Junior Poster in Training

Re: csv problem

Mar 29th, 2007

pls send me a sample program with syntax in c++ so that i can study the program.. pls help me.. i am just a beginner and using c++ just 3 days ago. i hope you understand.. thanks..

•

Join Date: Mar 2007

Posts: 61

Reputation: squinx22 is an unknown quantity at this point

Solved Threads: 0

squinx22

Offline

Junior Poster in Training

Re: csv problem

Mar 29th, 2007

•

Originally Posted by Ancient Dragon

In your example if you enter "205" you will get nothing because there are no lines that contain "205" But I understand what you mean anyway.

>>pls include the codes
Please first post your code to show us the effort you are making to solve the problem.

I would read the file one line at a time using fgets() function. Then you can use either strstr() to see if the line contains the search string, such as "205" and if it exists print the remainder of the line.

Code the problem one small step at a time to help from getting overwhelmed with the assignment. First, write the program that just opens the file. Get that to compile and work correctly. Then add to it the code needed to read each line using fgets(). Once that works you can continue with the reset of the assignment.

:eek:this is the program ive made earlier.. but it seems insufficient. it only reads the first line.. how cud i read each and every line one at a time?? thanks in advance...

 Help with Code Tags 
 c Syntax (Toggle Plain Text) 
#include <iostream>
#include <string>
#include <stdio.h>
 
using namespace std;
 
int main()
{
FILE *fp;
char data[50], *sd, p[50];
cout<< "Pls enter the string";
cin>> p;
fp=fopen("q.csv", "r");
if(fp==NULL)
{
perror("Problem encountered");
}
else
{
fgets(data, 50, fp);
sd=strstr(data,p);
if(sd!=NULL)
{
puts("file found");
}
else
{
puts("file not found");
}
puts(data);
}
return 0;
}
#include <iostream>
#include <string>
#include <stdio.h>

using namespace std;

int main()
{
FILE *fp;
char data[50], *sd, p[50];
cout<< "Pls enter the string";
cin>> p;
fp=fopen("q.csv", "r");
if(fp==NULL)
{
perror("Problem encountered");
}
else
{
fgets(data, 50, fp);
sd=strstr(data,p);
if(sd!=NULL)
{
puts("file found");
}
else
{
puts("file not found");
}
puts(data);
}
return 0;
}

Last edited by WaltP; Mar 29th, 2007 at 2:15 pm. Reason: Add CODE tags -- explained on the background of the post text box -- and FORMAT your code

•

Join Date: Feb 2007

Posts: 539

Reputation: thekashyap will become famous soon enough

Solved Threads: 50

thekashyap thekashyap is offline

Offline

Posting Pro

Re: csv problem

Mar 29th, 2007

A few comments:
1. You're never using "p".
2. you don't have a loop to read till the end of file. Lookup the code snippets, I'm sure somewhere you'll find some code that reads from a file.

•

Join Date: Aug 2005

Posts: 15,151

Reputation: Ancient Dragon has a reputation beyond repute

Solved Threads: 1435

Ancient Dragon Ancient Dragon is offline

Offline

Most Valuable Poster

Re: csv problem

Mar 29th, 2007

•

Originally Posted by squinx22

pls send me a sample program with syntax in c++ so that i can study the program.. pls help me.. i am just a beginner and using c++ just 3 days ago. i hope you understand.. thanks..

That's a pretty complex assignment for someone who has only been studying c language for three days. If you are learning on your own you should start at the beginning of the book you are reading (you ARE studying a book aren't you???) and not in the middle.

Don't PM me with questions -- you might get a nasty PM in response. If you have a question then post it in one of the forums.

•

Join Date: Mar 2007

Posts: 61

Reputation: squinx22 is an unknown quantity at this point

Solved Threads: 0

squinx22

Offline

Junior Poster in Training

Re: csv problem

Mar 29th, 2007

•

Originally Posted by Ancient Dragon

That's a pretty complex assignment for someone who has only been studying c language for three days. If you are learning on your own you should start at the beginning of the book you are reading (you ARE studying a book aren't you???) and not in the middle.

How could I separate the strings separated by commas and consider it as one string?

for example, i have a csv file:

from to name nick
0, 100, "help", "HP"
101, 201, "son", "SB"
202, 302, "dot", "DT"

if i enter a value the display wud be the nick. I must consider from and to.
for example

i entered 109, the program will then go to the second line since the value entered is in between the values 101 and 201. the output should be DT.

thanx in advance...

•

Join Date: Mar 2007

Posts: 61

Reputation: squinx22 is an unknown quantity at this point

Solved Threads: 0

squinx22

Offline

Junior Poster in Training

Re: csv problem

Mar 29th, 2007

•

Join Date: May 2006

Posts: 3,114

Reputation: WaltP has much to be proud of

Solved Threads: 281

WaltP

Offline

Posting Sensei

Re: csv problem

Mar 30th, 2007

Look at the first character
If it's a digit, call a function that converts the next values up to the comma into a number. Return the next location (pointer or index) in the string just after the comma

If it's a ", call a function that moves everything up to the next " into a character buffer. Return the next location (pointer or index) in the string just after the comma

repeat the above two texts until you run out of characters for the line.

The 3 Laws of the Procrastination Society:
1) Never do today that which can be put off until tomorrow
2) Tomorrow never comes

•

Join Date: Mar 2007

Posts: 61

Reputation: squinx22 is an unknown quantity at this point

Solved Threads: 0

squinx22

Offline

Junior Poster in Training

Re: csv problem

#10

Mar 30th, 2007

•

Originally Posted by WaltP

Look at the first character
If it's a digit, call a function that converts the next values up to the comma into a number. Return the next location (pointer or index) in the string just after the comma

If it's a ", call a function that moves everything up to the next " into a character buffer. Return the next location (pointer or index) in the string just after the comma

repeat the above two texts until you run out of characters for the line.

:eek:I still cant understand. can you sate a sample pls? thanx..