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