Forums
This topic is locked
Argh! Text file datasources ?
Posted 22 Oct 2001 16:10:09
1
has voted
22 Oct 2001 16:10:09 Adam Cronin posted:
Ok, heres a good one <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>A text file is uploaded to a reporting page containing a load of numbers, eg:
25
56
89
45
etc.
Theyre not formatted in any way except a return after each one. What im looking for is some help on using this text file as a datasource so I can ultimately create something to search these numbers and report back whether any of them are above a number, 75 for example. So If we take that load of numbers above, somehow a script is executed where those numbers are searched and it comes back saying that one of the numbers is over 75. It doesnt have to pinpoint the exact number - ill leave the user to that one - It just has to say somewhere in that text file there is a number[s] out of compliance.
Im thinking along the lines of using the Microsoft Text driver under the ODBC settings, and then go from there with UDev - but I havent got a clue how the text should be formatted.
Is there anyone out there that could offer some guidance. If not using the text driver then something else that could or would work ?
Thanks, as usual <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
Replies
Replied 24 Oct 2001 18:53:41
24 Oct 2001 18:53:41 Adam Cronin replied:
<img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle> - no-ones got any idea's ?
What about this..
I know javascript cant physically open a .txt file, but what If I was to display the file in a frame, JS can read text from withing a page right ?
Mr.Martinez <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> - youve helped me out before with a little script for a calculator - any chance you could chuck out a script to do the above ? <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
Thanks again for anyones help.
What about this..
I know javascript cant physically open a .txt file, but what If I was to display the file in a frame, JS can read text from withing a page right ?
Mr.Martinez <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> - youve helped me out before with a little script for a calculator - any chance you could chuck out a script to do the above ? <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
Thanks again for anyones help.