Reading Text Delimited
I have the below code found on an ASP site.
<%
arrName = Split(Request("TextArea"),",")
%>
<%
For i = LBound(arrName) To UBound(arrName)
Response.Write "ID: " & arrName(i) & "<br>"
Next
%>
I'm using a TextArea box to submit the following...
A123,1
B123,2
C123,3
Results are...
ID: A123
ID: 1 B123
ID: 2 C123
ID: 3
I expected something like...
A123 1
B123 2
C123 3
For the sake of understanding, why are the results like above?
In the end, I want to insert these values into a table.
A123 into Field1 .... 1 into Field2
B123 into Field1 .... 2 into Field2
C123 into Field1 .... 3 into Field2
Where do I start?
View Replies
ADVERTISEMENT
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
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
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 know how I could accomplish this without using DB. There's a long text file named "TEST.TXT" The TEST file contains special character 'º' which will be used as pagebreak. I want an ASP page that will read the TEST.TXT file and split it into multiple web pages with navigation control. (eg. <FIRST<PREVIOUS>
<NEXT<LAST)
If it is possible
View Replies
View Related
I have a form that updates a text file. This text file writes variables (i.e. username = tom). This file is used to preview an HTML page and when you go to the form the variables are populated into the form fields again.
For some reason when someone else modifies the text file (using the form) I only see the old contents in the form fields. When I look at the preview HTML file, however, everything is fine.Why doesn't the form re-populate with the new info?
View Replies
View Related
i have a variable 'user', and a text file 'users.txt'. how can i search the text file and select the line thats the same as the variable 'user', then put that line into a variable?
'user' = 'root'
'users.txt' =
testuser1|kfkfjd
root|18273
test2|fjfkds
View Replies
View Related
I was under the impression if I had a page with several database queries to 3 different databases, it would be faster if I just had the queries cached to text files since the query result won't change that often and I build the cache manually when needed.
So my question is would it be faster to just include text files instead of doing multiple Access and SQL queries on a web page?
View Replies
View Related
I need to create something that will read a text file and send e-mail statements from that text file. I know this is a basic application, but I am not sure where to start with this. The text file already contains all of the information for the statements. It is one file that starts with the customer e-mail address and then separates each statement by an <eob> marker. I need to be able to browse to upload the file and then have the application cycle through and generate all of the e-mails. I don't need to do any formatting to the text file, just read it and send the e-mails. The server currently uses CDOSYS to send other e-mails from a shopping cart application.
View Replies
View Related
I have some messages in a text file.I would like to read one message every day from the text file. My Text file looks something like this
If you take medication for your blood pressure, you may need to be wary of adding certain pain relievers to your system. A class of pain-relieving anti-inflammatory medication often used to treat arthritis may interfere with a common blood pressure medication, according to research. The hash is just for demarcation. As I havent worked much with FileSystem can anyone help me how to go about acheiving the same.
View Replies
View Related
I need to read a simple txt file where there are some variables. I've done
this a lot of times but in this case I have something different: the text
file is located at an ftp server.
The FTP server has anynomous access.
Anyone know how can I do this?
View Replies
View Related
I get a CD from O2 containing call data.I want to read the txt file on the CD and use the content of the textfile in an asp file to import to the database.But how do i read the file?
View Replies
View Related
the source code is:
<%
Set fso = CreateObject("Scripting.FileSystemObject")
Set a = fso.OpenTextFile(Server.MapPath("") & "/learn.txt")
mystring=a.readAll
Response.Write ("<pre>" & mystring & "</pre>")
Set a = Nothing
Set fso = Nothing
%>
The output is:
abc
ABC
i don't understand this:
Set fso = CreateObject("Scripting.FileSystemObject")
Set a = fso.OpenTextFile(Server.MapPath("") & "/learn.txt")
what should be insect in ("Scripting.FileSystemObject")?
and what should be insect in (Server.MapPath("") & "/learn.txt") ?
View Replies
View Related
Here is what I have setup:
- a form that updates a text file.
- for example, in the form I have two fields, title and story. then, this write to a textfile (i.e. theinfo.asp). the update.asp file looks like this:
TSO.write "<%" & vbCrLf
TSO.write "title = """
TSO.write Request.Form("title")
TSO.write """" & vbCrLf
TSO.write "story = """
TSO.write Request.Form("story")
TSO.write """" & vbCrLf
- so, essentially it is creating an asp file with two variables.
- this works fine, it updates the file and i can call these variables in other pages. however, when i call these variables into a form : old versions of the variables populate the form: Code:
View Replies
View Related
i had a vbscript that will read the text file from the bottom to the top, and after reading the file, it will be displayed in the screen, and the code look like this:
PHP Code: Code:
View Replies
View Related
I have to make a site search function for my website. User types a keyword, and the search function searches through all the static pages for the keyword. The result of the search has to display the URL relating to the keyword, which the user can click to read the contents.
I had no idea how to go about doing it, finally I thought of using a textfile containing the word, and its related URL in the format: Code:
View Replies
View Related
I found the complete physical path to the doman by Response.Write Server.MapPath(".") and the path is: C:Inetpubwwwrootmyweb"&"gg.txt
With this,there's still error to read my text file.The error source code is place at below,please help me do correction!!! Code:
View Replies
View Related
can anyone put me on the right track.i have a comma delimited file and i need to search through this file and locate where acctsessionid does not have 2 matching records and display them on an asp page.
View Replies
View Related
need to query a database and then get the results in a tab delimited file.currently am writing record by record in the file using the FSO,but just wanted to check can we directly get the results in the TAB delimited format and save to a file on the server.
View Replies
View Related
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
What's the easiest way to generate CSV or a comma delimited file from an ASP
recordset? I've seen a few searching the internet and they appear to be
overkill or out of date.
View Replies
View Related
Whenever I import a comma delimited file the field lengths are always 255. I tried an import specification in my code but they were stll 255 in length.
I imported about 156 fields and about 140 came in at 255. Not gonna work.
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
How can I populate the results of a recordset into a comma delimited?
The recordset is only returning a sequence of ID's (one column - one dimension). I was trying the getRows and getString method. If the result was only one record it was okay, but for more than one result I was getting an unhandled data type error.
I would just like to place the values from the recordset into a comma-delimited list and then pass that into a javascript function?
View Replies
View Related
Due to using a combo of OLEDB/ADO/ASP and JavaScript I was having trouble
reading in CSV data so I converted my client's web site to use tab-delimited
instead. Better for me, but client is adamant that their site's recent
timeout problems are since I converted to this tab format?? Code:
View Replies
View Related
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
View Related
I have written an ASP script that collects information from a form. The info is stored in one variable name. When I request the info, it is returned as a comma delimited string. How can I manipulate this string so the data can be stored in a database? I appreciate your assistance.
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
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
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
I have a sql server 2000 table with a comma delimited list of ids. there is a seperate lookup table with a desc for each id.
I need for this data to be retuned in the same order in which the data was entered into the database. right now it is returning ordered by the id from the lutable.
View Replies
View Related
I want to use a simple CDONT mail script to allow the administrator of a site to send an email blast to their users. there are approx 1600 emails in the MS SQL db table. I would like to parse the entire email address column and get a variable that is all the email addresses separated by a comma so that the form picks it up as all the emails in the 'bcc' field as in the eg. below..I know there has to be an easier way but I want to get these guys up and running.
<%
objCDO.To = "Recipient@oursite.org"
objCDO.From = "mailer@oursite.org"
objCDO.bcc = "$variable_of_all_email_addresses"
Dim txtSubject
txtSubject = "Insert comments and case info here"
objCDO.Subject = ""***ATTENTION*** NEW CASE - MISSING CHILD"
objCDO.Body = txtSubject
objCDO.Send
%>
View Replies
View Related
