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 Authementjpauthement@.gmail.com wrote in news:1135186850.601197.18460
@.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 : )
Stan Kee (spamhoneypot@.rogers.com)
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment