Read Tab Delimited File Into An Array With ASP
I need to read a tab delimted file into an array with ASP. Should be
easy enough, I know it is in Perl and PHP. Can someone show me how
that's done or post a link to an example.
This is what I'm trying to do in perl:
#!/usr/bin/perl -w
my $file = "myfile.txt";
open(FILE, $file);
while(<FILE>){
my ($f1, $f2, $f3) = split(' ', $_); # or @array = split(' ', $_)
print "F1:$f1 F2:$f2 F3:$f3
";
}
close(FILE);
View Replies
ADVERTISEMENT
I need to be able to read a tab delimited text file with an asp page so that I can stuff the fields into a sql table.I really don't know how you can do that, I checked the books I have and have been running around the internet trying to find the answer when I found this site.I cannot use a bulk insert statement because I don't have that level of access to the sql server. and I was assured that "BCP is indeed a command-line only utility and cannot be launched from ASP. You could parse the text file with ASP and generate INSERT statements that you then execute against the database. Routines for parsing tab-delimited files can be had by searching for them on google quite easily." by the system administrator
View Replies
View Related
Anyone know the best way of Read tab delimited text file, its old but I have to use it, I only know how to read csv.
View Replies
View Related
I'm trying to read a tab-delimited file into an array so I can pick out different fields for a report. I keep getting a "Type Mismatch" error that I don't understand.
sReceiveFile = "receipt.txt"
sDataFile = sReceiveFolder & sReceiveFile
sDelimiter = "Chr(9)"
Dim objFileSystem, objFile
Set objFileSystem= CreateObject("Scripting.FileSystemObject")
Set objFile = objFileSystem.OpenTextFile(sDataFile,1)
sReadLine = objFile.readline
Do While objFile.AtEndOfStream <> True
Response.Write "<UL>" & Chr(10)
'Response.Write objFile.ReadLine & "<br>"
sSplit = split(objFile.Readline,"Chr(9)")
Response.write sSplit ' I want to see the contents and this line is giving me the error
Response.Write "</UL>" & Chr(10)
Loop
objFile.Close
%>
View Replies
View Related
i am trying to run a asp sql query containging many tables. the main table though is a simple ID based table contains all ids from the other tables. Code:
View Replies
View Related
I need to create a 2 dimensional array from a string with 2 kinds of delimiters
sample string: Code:
View Replies
View Related
In an application I'm working the user has the opportunity to record the
despatching of one or more items with serial numbers.
For each item they despatch, they have to chose the serial no that they want
to despatch from a list of available ones. In many cases, these items will
be of the same time, so the dropdown of available serial no's may be the
same. Code:
View Replies
View Related
I've been asked to develop a semi-automated type situation where we have a
database table (sql server) and periodically, there will be a comma
delimited file from which we need to import the data, replacing the old.
I naurally know that we can use [truncate tablename] to kill the other data,
but does anyone have any examples of importing a comma delimited file into
SQL Server with ASP?
View Replies
View Related
Is it possible to have a search page that queries a sql database and then writes the results to a comma-delimited text file instead of displaying the results.
I have no problem creating the search page and displaying the results I just don't know how to create the comma-delimited text file from the recordset results.
View Replies
View Related
how to create a comma delimited text file from an asp form. Assume my fields are: Name, email, phone number.
View Replies
View Related
I would like to use ASP to populate a select list from a comma delimited txt file.....
View Replies
View Related
i'm converting an image file to hexa..then the hexa is saved to a text file..
can any one help me how to read the content text of a text file?...
im doing it this way because i don't want to save hexa in my database, because it makes the database slower to open up.
View Replies
View Related
I have code that loops through a directory reading files..
now the problem is that files are constantly being uploaded and I only want the file system object to read those that are finished being uploaded.
How can I check the properties of the file to see if it's in middle of being written before i read the file?
View Replies
View Related
I want to read an asp file as a text file. The problem is that the file that I want it to read is located on a server. For example: I want to read te content of this file: http://www.bnro.ro/Ro/Info/default.asp . I want to look after some values in that file.
View Replies
View Related
I have an asp application in which, a page generates reports depending upon the id passed to it. For eg. printpage.asp?id=52 . Now I have a Print button on this page on clicking of which the contents of the page should be read and passed to the activex dll which I have prepared for printing the page.( I had to do this because the printer is installed on the server where the application resides and it should print on the server printer).
Now my question is how to read the asp file (say printpage.asp?id=52) contents in such a way that the fonts and formatting should remain the same, as that content will be printed on the server printer using Active X dll.
View Replies
View Related
how to read the contents of a PDF file from an ASP page? I am trying to create a search engine that displays PDF files and Docs as links in an ASP page once the search request is submitted.
View Replies
View Related
I am trying to read a file through classic ASP. The file is located on a file server, seperate from the webserver. This is the path I'm trying to read the file from
FILESERVERMYFOLDERmyfile.txt . How can I accomplish this task?
View Replies
View Related
I'm looking to display a 'phonebook' which will read the columns in a .csv or .txt file and display them in a sortable table by column. Here is what I have an excel file which has nearly 550 first, and last names, extensions, phone numbers, and office locations which I'd like to display on our companies intranet.
I'm looking for a way to show the table in a window with column headings that are clickable to sort by first, last and office name in an alphabetical fashion. Any direction to tutorials, free stuff or development here.
View Replies
View Related
If ASP can read remote file like php does.I am trying to read this weather forecast page, and only output certain line from it.I only know how to read a local file using server.mapPath()
View Replies
View Related
I'm write an asp to include part of a text file into my asp output html, I use FileSystemObject to get the content of the text file, but the asp just hang when it runs, the source code is listed below if anyone could help: Code:
View Replies
View Related
How can I read a file from a website ?For example, I would like to read http://www.website.com/news.htm, can I do that ?
View Replies
View Related
I'm using ASP to generate an RTF (rich text) file, via the FSO. No problems with text, but when it comes to inserting images, the files have to be embedded as either binary or hex.
Try as I might, I can't get binary to work (Word b0rks trying to open the resulting file). When I create a simple RTF in Wordpad and then view its source, Wordpad seems to be embedding the image as hex. Does anyone have a suggestion as to how I could read an image file off the disk in hex format for writing into my RTF?
View Replies
View Related
I have a pdf file,in a directory c:inetpubwwwrootproject. i am using PDF component to read it. but I am getting error. Unable to read file.
View Replies
View Related
We have a page which we want to allow our users to download files. Can someone point to peice of code that we can use to force the download as opposed to opening the files in the browser.
Only one issue here the code need to work with UNC path like myserverfiles and not just c:inetpubwwwrootfiles. I did have a look on internet but all of the code seems to be using localpath names but none with UNC path name.
View Replies
View Related
I am unable to read a network file using ASP. I am using FileSytemObject to read the file.
View Replies
View Related
I tried to read a text file from my local com, but it keep on loading and loading, after tat, i'll need to restart my IIS... im sure tat the directory of the txt file is correct... The code is running very well in another com, is there any kind of permission/ something i missed?
View Replies
View Related
if someone can help me on VB/ASP.Net project. The project was
developed by another developer on another machine. I need to load it and
make some changes to this project. I get error message "Unable to read
project file (name of the file). The Project file has been renamed or is no
longer in the solution.
View Replies
View Related
Actually, I do not know why i can not add records to my access database table by using asp code, I get an error that tells me that the database file or object is read only file even though the file is not readable only from its proprties, I need some helpful information to solve this problem.
View Replies
View Related
I have to read a XML file in ASP and save the values in a database. I can get this work, but I cannot read some nested nodes of the xml file. This is a part of the XML file: Code:
View Replies
View Related
I would like to allow my customers to upload their log files so that I can analyze them. Using ASP, I've found ways to:
1) upload files using the standard form elements and save it to my server using:
Code:
<input type= file>
2) from the file on my server, i can parse the text file and return results to the user
However, I would prefer not saving hundreds of random text files on my server. Is there a way that I can see the contents of the uploaded text file using ASP without saving it to the server? Is there something using the filesystemobject that allows me to do this?
View Replies
View Related
I am working on a safetywear deduction system and i need to perform the following functions: write to a text file and read from a test file and wrute to a table in the database. I need code to write and read to a text file in asp please.
View Replies
View Related
My xml file format is below:
<content> node have HTML format data i read xml file i got values but not in html format i also post asp code for reading xml file Code:
View Replies
View Related
Anyone know how to read excel file with ASP and stored it in database?
View Replies
View Related