Text File Query

[jpauthement]

I have an application which searches through a comma-delimited text
file which looks similar to this:

"012233010","PAMIC 6X8","FA","0.000","0.000"
"012233011","PAMIC 8X8","FA","1.000","0.000"

The text file is a dump from an asp/400 system. And it is automatically
ftp-ed to the website.
The question i have is: Is it possible to do a query on the text file
similar to
Select * from INV.txt Where field0 = "1234"

In working with the document in my development environment, I added a
line to the beginning of the file containing all of the column headers.
And everything works perfectly. But my uploaded raw version won't have
the headers included. Thats why i wanted to know if you could run
queries on a text file without column header names using field numbers
instead.

Thanks.
Johnny Authement

 

[Guest]

(e-mail address removed) wrote in @g47g2000cwa.googlegroups.com:

The question i have is: Is it possible to do a query on the text file
similar to
Select * from INV.txt Where field0 = "1234"

Yes - you can use Microsoft's Text Driver. It's built into Windows : )