I have an application that can only export to a comma delimited text file. The application does not let me format what data is incuded basically spits out the whole table. I cannot query the table directly because first it's not in the same network then the webserver and it's BTrieve 
Now my question, I created a file which takes that text file, formats it a little and displays it within an intranet. Now there are three columns that I don't want to display ( the first, third and fourth) where the whole text file has like 10 columns. Anyone got an idea how?? No ideas how to query a text file and the person who is gonna do the exports will not go through the process of importing them to a database.
Here is what I have so far:
<%
' This script only works with the interchange export from OPS
fontsize = "-5" 'please specify the desired font size here -6 , -5 , .... , +5 , +6
fontface = "Times New Roman" 'please specify the desired font face here (Arial or whatever you prefer.)
whichfile=server.mappath("/export.txt") 'change the filename of the txt file here, have it in the same dir as this asp file
Set fs = CreateObject("Scripting.FileSystemObject")
Set thisfile = fs.OpenTextFile(whichfile, 1, False,TristateFalse)
counter=0
do while not thisfile.AtEndOfStream
thisline=thisfile.readline
tableline = "<tr><td nowrap><font size=" & fontsize & " face=" & fontface & ">" & Replace(thisline,",","</td><td nowrap><font size=" & fontsize & " face=" & fontface & ">") & "</td></tr>"
tableline = Replace(tableline,"""","")
Response.Write tableline
loop
thisfile.Close
set thisfile=nothing
set fs=nothing
%>
Topic Options
Post Options
Thanks(0)
