How do I read a csv file into a structure?

[Vasilis Serghi]

Hi all, I am fairly new to C programming and I have come to a stand still. I
am trying to create a program that will accept a user input and give the
user an output depending on the contents of a csv file. So far I have
successfully managed to capture the user input, open the csv file, create a
structure that matches the file data, but I cannot get the data into the
structure to do a search on.

This is some of what I have done so far:-

#define NUM_OF_ROWS 437
#define NUM_OF_COLUMNS 3
FILE *errorFile;
struct csvFileData {
char dtcDesc[NUM_OF_ROWS];
int errorNum[NUM_OF_ROWS];
char dtcNum[NUM_OF_ROWS];
}dtcInfo;

if ((errorFile = fopen("Error_Loc.csv","r")) == NULL)
{
fprintf(stderr,"\nError opening \"Error_Loc.csv\" file. \
\nMake sure the file is in the same folder as this program.
\nProgram will now exit. ");
system("PAUSE");
exit(1);
}

fclose(errorFile);

I assume that as I didn't get the error for fprintf, then the file was
opened and closed ok.

My question is, how do I get the contents of the errorFile into my
structure?

If the user selects 14 as an error number for example, how can I do the
search on the structure to give me back the dtcInfo.dtcDec and
dtcInfo.dtcNum that corresponds to the error number requested?
How can I initialise the structure with zeros for the int and spaces for
char?

Again sorry if this is basic stuff. Any help is greatly appreciated.

--
Vas

(These are my own thoughts and views and not the views of my employer.)

[Vasilis Serghi]

"Vasilis Serghi" <vs*****@jaguar.com> wrote in message
news:bu*********@eccws12.dearborn.ford.com...

Hi all, I am fairly new to C programming and I have come to a stand still. I am trying to create a program that will accept a user input and give the
user an output depending on the contents of a csv file. So far I have
successfully managed to capture the user input, open the csv file, create a structure that matches the file data, but I cannot get the data into the
structure to do a search on.

This is some of what I have done so far:-

#define NUM_OF_ROWS 437
#define NUM_OF_COLUMNS 3
FILE *errorFile;
struct csvFileData {
char dtcDesc[NUM_OF_ROWS];
int errorNum[NUM_OF_ROWS];
char dtcNum[NUM_OF_ROWS];
}dtcInfo;

if ((errorFile = fopen("Error_Loc.csv","r")) == NULL)
{
fprintf(stderr,"\nError opening \"Error_Loc.csv\" file. \
\nMake sure the file is in the same folder as this program.
\nProgram will now exit. ");
system("PAUSE");
exit(1);
}

fclose(errorFile);

I assume that as I didn't get the error for fprintf, then the file was
opened and closed ok.

My question is, how do I get the contents of the errorFile into my
structure?

If the user selects 14 as an error number for example, how can I do the
search on the structure to give me back the dtcInfo.dtcDec and
dtcInfo.dtcNum that corresponds to the error number requested?
How can I initialise the structure with zeros for the int and spaces for
char?

Again sorry if this is basic stuff. Any help is greatly appreciated.

--
Vas

(These are my own thoughts and views and not the views of my employer.)

I should also add that the csv file is a 437x3 array. It contains mixed data
hence the structure route. And I have also changed the following lines.

struct csvFileData
{
int errorNum[NUM_OF_ROWS][NUM_OF_COLUMNS];
char dtcDesc[NUM_OF_ROWS][NUM_OF_COLUMNS];
char dtcNum[NUM_OF_ROWS][NUM_OF_COLUMNS];
}dtcInfo;

--
Vas

(These are my own thoughts and views and not the views of my employer.)

[Michael B Allen]

On Mon, 19 Jan 2004 13:36:32 -0500, Vasilis Serghi wrote:

My question is, how do I get the contents of the errorFile into my
structure?

Try this and look at the tcase/tests shipped with the lib:

http://www.ioplex.com/~miallen/libmba/dl/src/csv.c

Mike

[Thomas Matthews]

Vasilis Serghi wrote:

Hi all, I am fairly new to C programming and I have come to a stand still. I
am trying to create a program that will accept a user input and give the
user an output depending on the contents of a csv file. So far I have
successfully managed to capture the user input, open the csv file, create a
structure that matches the file data, but I cannot get the data into the
structure to do a search on.

This is some of what I have done so far:-

#define NUM_OF_ROWS 437
#define NUM_OF_COLUMNS 3
FILE *errorFile;
struct csvFileData {
char dtcDesc[NUM_OF_ROWS];
int errorNum[NUM_OF_ROWS];
char dtcNum[NUM_OF_ROWS];
}dtcInfo;

if ((errorFile = fopen("Error_Loc.csv","r")) == NULL)
{
fprintf(stderr,"\nError opening \"Error_Loc.csv\" file. \
\nMake sure the file is in the same folder as this program.
\nProgram will now exit. ");
system("PAUSE");
exit(1);
}

fclose(errorFile);

I assume that as I didn't get the error for fprintf, then the file was
opened and closed ok.

My question is, how do I get the contents of the errorFile into my
structure?

If the user selects 14 as an error number for example, how can I do the
search on the structure to give me back the dtcInfo.dtcDec and
dtcInfo.dtcNum that corresponds to the error number requested?
How can I initialise the structure with zeros for the int and spaces for
char?

Again sorry if this is basic stuff. Any help is greatly appreciated.

--
Vas

(These are my own thoughts and views and not the views of my employer.)

Personally, I would think of this as fields and records. Each column
is a field and each row as a record. Your file represents a container
of records (just in a different format).

struct File_Record
{
char * dtc_description;
int error_number; /* should this be unsigned??? */
char dtc_number; /* why char and not int? */
};

struct File_Record array_of_records[NUM_ROWS];

I didn't specify the dtc description as a fixed length of characters
since I didn't know the maximum width. I have left it as a pointer
so that room for the text can be allocated during run-time.

As far as searching for an error number, all you have to do is
to look at array_of_records[i].error_number for all i, 0 .. NUM_ROWS.

I suggest you use a dynamic container, such as a linked list, since
the number of rows may vary.

--
Thomas Matthews

C++ newsgroup welcome message:
http://www.slack.net/~shiva/welcome.txt
C++ Faq: http://www.parashift.com/c++-faq-lite
C Faq: http://www.eskimo.com/~scs/c-faq/top.html
alt.comp.lang.learn.c-c++ faq:
http://www.raos.demon.uk/acllc-c++/faq.html
Other sites:
http://www.josuttis.com -- C++ STL Library book

[Joe Wright]

Vasilis Serghi wrote:

"Vasilis Serghi" <vs*****@jaguar.com> wrote in message
news:bu*********@eccws12.dearborn.ford.com...

Hi all, I am fairly new to C programming and I have come to a stand still.

I

am trying to create a program that will accept a user input and give the
user an output depending on the contents of a csv file. So far I have
successfully managed to capture the user input, open the csv file, create

a

structure that matches the file data, but I cannot get the data into the
structure to do a search on.

This is some of what I have done so far:-

#define NUM_OF_ROWS 437
#define NUM_OF_COLUMNS 3
FILE *errorFile;
struct csvFileData {
char dtcDesc[NUM_OF_ROWS];
int errorNum[NUM_OF_ROWS];
char dtcNum[NUM_OF_ROWS];
}dtcInfo;

if ((errorFile = fopen("Error_Loc.csv","r")) == NULL)
{
fprintf(stderr,"\nError opening \"Error_Loc.csv\" file. \
\nMake sure the file is in the same folder as this program.
\nProgram will now exit. ");
system("PAUSE");
exit(1);
}

fclose(errorFile);

I assume that as I didn't get the error for fprintf, then the file was
opened and closed ok.

My question is, how do I get the contents of the errorFile into my
structure?

If the user selects 14 as an error number for example, how can I do the
search on the structure to give me back the dtcInfo.dtcDec and
dtcInfo.dtcNum that corresponds to the error number requested?
How can I initialise the structure with zeros for the int and spaces for
char?

Again sorry if this is basic stuff. Any help is greatly appreciated.

--
Vas

(These are my own thoughts and views and not the views of my employer.)

I should also add that the csv file is a 437x3 array. It contains mixed data
hence the structure route. And I have also changed the following lines.

struct csvFileData
{
int errorNum[NUM_OF_ROWS][NUM_OF_COLUMNS];
char dtcDesc[NUM_OF_ROWS][NUM_OF_COLUMNS];
char dtcNum[NUM_OF_ROWS][NUM_OF_COLUMNS];
}dtcInfo;

We might have a problem with terms. A .csv file is a text file
representing a two dimensional table of rows of columns. The first row
(line) is usually the field name. For example:

custno,first,last,addr,city,state,zip
1,John,Kerry,1 Main St,Des Moines,IA,
2,Joe,Wright,28th Rd,Arlington,VA,22206

Does your .csv file look anything like this?
--
Joe Wright http://www.jw-wright.com
"Everything should be made as simple as possible, but not simpler."
--- Albert Einstein ---

[Vasilis Serghi]

"Joe Wright" <jo********@earthlink.net> wrote in message
news:40***********@earthlink.net...

Vasilis Serghi wrote:

"Vasilis Serghi" <vs*****@jaguar.com> wrote in message
news:bu*********@eccws12.dearborn.ford.com...

Hi all, I am fairly new to C programming and I have come to a stand still.

I

am trying to create a program that will accept a user input and give

the user an output depending on the contents of a csv file. So far I have
successfully managed to capture the user input, open the csv file, create a

structure that matches the file data, but I cannot get the data into

the structure to do a search on.

This is some of what I have done so far:-

#define NUM_OF_ROWS 437
#define NUM_OF_COLUMNS 3
FILE *errorFile;
struct csvFileData {
char dtcDesc[NUM_OF_ROWS];
int errorNum[NUM_OF_ROWS];
char dtcNum[NUM_OF_ROWS];
}dtcInfo;

if ((errorFile = fopen("Error_Loc.csv","r")) == NULL)
{
fprintf(stderr,"\nError opening \"Error_Loc.csv\" file. \
\nMake sure the file is in the same folder as this program.
\nProgram will now exit. ");
system("PAUSE");
exit(1);
}

fclose(errorFile);

I assume that as I didn't get the error for fprintf, then the file was
opened and closed ok.

My question is, how do I get the contents of the errorFile into my
structure?

If the user selects 14 as an error number for example, how can I do the search on the structure to give me back the dtcInfo.dtcDec and
dtcInfo.dtcNum that corresponds to the error number requested?
How can I initialise the structure with zeros for the int and spaces for char?

Again sorry if this is basic stuff. Any help is greatly appreciated.

--
Vas

(These are my own thoughts and views and not the views of my employer.)

I should also add that the csv file is a 437x3 array. It contains mixed

data hence the structure route. And I have also changed the following lines.

struct csvFileData
{
int errorNum[NUM_OF_ROWS][NUM_OF_COLUMNS];
char dtcDesc[NUM_OF_ROWS][NUM_OF_COLUMNS];
char dtcNum[NUM_OF_ROWS][NUM_OF_COLUMNS];
}dtcInfo;

We might have a problem with terms. A .csv file is a text file
representing a two dimensional table of rows of columns. The first row
(line) is usually the field name. For example:

custno,first,last,addr,city,state,zip
1,John,Kerry,1 Main St,Des Moines,IA,
2,Joe,Wright,28th Rd,Arlington,VA,22206

Does your .csv file look anything like this?
--
Joe Wright http://www.jw-wright.com
"Everything should be made as simple as possible, but not simpler."
--- Albert Einstein ---

Yes it looks like that. Since then I have been wondering whether it will be
easier to just scan the file for the information I want when its needed, or
load the file into memory.
--
Vas

(These are my own thoughts and views and not the views of my employer.)