Read veriable length parameter from a string

I have a text file and each line has N variables(string) between " and ". Each variable length is not fixed and could be 0. How can I use a simple way to read them one by one.

"111","","defg"
"222","ABCDE","V22ds"
"321","dasdsa","s"
...

Thanks
ysimonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

schutnikCommented:
If you have a constant number of variables on each line, you could use the Text ODBC driver to access the file as a CSV file.

Kelly
0
ysimonAuthor Commented:
Could you please tell me more about CSV file. Can I build a database for that kind of text file?
0
ysimonAuthor Commented:
Could you please tell me more about CSV file. Can I build a database for that kind of text file?
0
Amazon Web Services

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

rwilson032697Commented:
Here is a delphi component for importing CSV files. Its free with source code.

http://delphi.icm.edu.pl/ftp/d30free/pgcsv.zip

"Comma Sepreted Value Import/Export compoent. Field mapping, Field ignoring, progress events, direct link to TTable, full customizable. This component is exclusively for Import and Export from/to CSV files. "

Cheers,

Raymond.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rwilson032697Commented:
Here is another one you could look at:

ftp://ftp.cdrom.com/pub/delphi_www/ftp/d20free/csvsinfo.zip

"This component takes a comma seperated string as input and splits it up into seperate fields that can be read out of a StringList. Handy for reading comma seperated files. See http://www.skybound.club.tip.nl for a sample application"

Cheers,

Raymond.
0
ysimonAuthor Commented:
Very good
I have solved my problem by using the CSV.
Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Delphi

From novice to tech pro — start learning today.