Replies to This Discussion

Permalink Reply by PSoftPros on February 17, 2010 at 6:33am

Hello,

You can open the file and read a line at a time.

Then use the unstring command to read each value separated by a comma.

Hope that helps.

• ▶ Reply

Permalink Reply by bithika on February 18, 2010 at 11:57pm

these will be the steps.
1. open the file.
2. read each line using the read command. after you read them, keep them in individual variables. you need to do this in a while loop till the end of file.
.
close the file.

You will get the syntax in a sqr guide. sqr guide is available in peoplebooks.

• ▶ Reply

Permalink Reply by Richard Schnitz on March 4, 2010 at 9:25am

Try this file. I've been using this since 2001. It was developed by Ray Ontka.

Attachments:

• csv.sqh, 5 KB

• ▶ Reply

Permalink Reply by rani on March 18, 2010 at 2:48pm

thanks a lot Richard Schnitz,,,


from rani

• ▶ Reply

Permalink Reply by PSoftPros on March 19, 2010 at 7:09am

This question was recently asked not too long ago.

Look at this thread

Read a CSV File

Good Luck

• ▶ Reply