How To Stop It Read The Datas In The Next Line In .csv File
i wrote this code to read the datas from excel(.csv file). but it read all the datas as 1 line. i don't undestand why.is there any function that i can use to stop it read the datas in the next line?? can anyone help me?? thanks a lot.
Do While Not TextStream.AtEndOfStream
line = TextStream.readline
if line <> "" then
arr_User(i) = trim(line)
splitline = split(arr_User(i), ",")
for j=0 to 5
response.Write splitline(j) &"nbsp;nbsp;"
next
i = i + 1
redim preserve arr_User(i)
end if
Loop
View Replies
ADVERTISEMENT
how can i read the datas in specific columns and rows from excel(.csv) file and then use that datas to calculate the min(example) and write the results into the same excel(.csv) file.
View Replies
View Related
I have an encrypted .txt file created by asp. Its formatted with lines etc. Title followed by description underneath. I need to read this into ASP now, and parse it line by line. On each line read, run the function to unencrpt and add line to a new file.
Its the line by line Im having trouble with. If i do the full textstream no formatting takes place coz im adding the fulltextstream all in one addline call. How can I loop through lines ?
View Replies
View Related
I have a log file from my email software program. Each entry is on a line and the values are seperated by tabs. How can I read through this text file such that I insert its contents into a database? Thanks. Tom
Here is one entry from that file:
11/30/06 00:00:21SMTP-IN25AA24076F2041D7B35E97EE7748D06C.MAI65284.244.91.208EHLOEHLO [84.244.91.208]250-home [84.244.91.208], this server offers 4 extensions11922
View Replies
View Related
I had created a macro to read data from an excel sheet and write the values to a text file. I had used "ActiveSheet.Range("GB" & k).Value" command to read the values from the excel.some cells in the excel sheet is having two lines value and four lines data, the text file is generating that value in a single line. (Ex. the cell value in address column is in four lines and should display in four lines in the text file generated from the macro)
Can i do something in the excel sheet or in vb script to read the address value line by line and write line by line in text file?
View Replies
View Related
I'm looking fo a solution to generate automaticaly a PDF file.
My aim is to use a template define by a user and to insert dynamicly
datas form SQL server in this document.
Can you tell me if it exist PDF template like .dot for word ?
If such file exist is it possible to generate list of information like
aacount report with datas coming for Database like Sql server.
View Replies
View Related
I wuz just wondering, whats the easiest way to read a text files last line...
I know i have to count the lines and put pointer to the last line and read from there.. but i cant get the hang of it
heres my code:
View Replies
View Related
I would like to know which ad is being presented through adrotator, so that I may write out some comments about the image presented. Would I use FSO to determine which line of code from the text file is being presented? If FSO is the answer, what would it look like?
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 collect datas (user input) from the form say form1.asp and if i press submit button it should straight away go to the emailid say contact@abc.com.
View Replies
View Related
help to slove the multiple posting
i have to run three .asp in seperate server to save the Orders in .mdb file. when user submit the order form on web page[Orders.htm] it should post it to
1. http://[ server1 ]/[file1].asp
2. http://[ server2 ]/[file2].asp
3. http://[ server3 ]/[file3].asp
4. to its own
View Replies
View Related
ASPError object gives the current line where error occurred. Is there a way to find out the line where Err.Number became non-zero due to a Server.CreateObject(...) failure?
View Replies
View Related
Please someone tell what is maximum lenght of Session- [item {field} ].
I am working on extreme binary data and it holding Session Variables.I don't no how much length should i give to the session variable.
Note: Binary data is nothing but a Image data: Code:
View Replies
View Related
I have a text file named "enterintro.bat". The contents of the file are:
@ECHO OFF
start /w C:skAppActivate.vbs "F4 Event and Entity"
start /w Sleep.vbs 2
start /w C:skSendKeys.vbs "BEC201_IPA{TAB}IPA_SS{ENTER}^S"
What I'm trying to do is to be able to swap out the "BEC201_IPA" and "IPA SS" with different variables. The format of the text file should never change except for swapping out these values. I've used the OpenTextFile method before, but only to append lines to a file, and never to replace an existing line, and I'm not sure how to do it. The best I've come up with so far is this: Code:
View Replies
View Related
I am writing one line and for a reason I ignore it adds a line which is screwing up a few things.
<%
Set fso = CreateObject("Scripting.FileSystemObject")
dim sLine sArchivo="switch.txt"
path = Server.MapPath("../Flash")
sFile = path & "" & sArchivo
if fso.FileExists(sFile) then
fso.DeleteFile(sFile)
end if
Set a = fso.CreateTextFile(sFile, True)
if request("radiobutton") = 1 then
sLine = "&ver=si"
else
sLine = "&ver=no"
end if
a.WriteLine (sLine)
a.Close
sRedirect="admin_NoticiasListado.asp?sRadio=" & request("radiobutton")
Response.Redirect(sRedirect)
%>
How come does the extra line come ? I seems I have done already a fews times and it never ocurred before.
View Replies
View Related
is it possible to include a line of asp in a .html file?
View Replies
View Related
if I had a form using the input textboxes using username and password. how do I use the .asp language to remove the line from a .txt using the following format:
username<space>password
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 Access DB with newsletter preferences in it. What I am trying to do is select small groups to send a custom newsletter out to. So my localhost criteria web page goes to the Access DB and pulls the email addresses that match my current criteria. I then write that list out to a file (newsletterlist.txt). Maybe that is my problem, but I wanted to do that so if my machine crashed while processing, I would know where to recover it. I had looked at arrays and dictionaries but dictionaries aren't good from what I found for hundreds of entries and arrays I can't keep track of..argh.
Anyways, I then wanted to loop through the file (newsletter.txt) find the next email address, with it I can query back to the DB and get preferences and assemble the email and out the custom newsletter goes.
I've seen where MS says deleting a line using the FileSystemObject is not possible, though wanted to see if anyone has found a work around.
Performance isn't that much of an issue for me, as I figured I'd set the thing to running and go to dinner! So anyone have suggestions - even if it means taking the text info to an array, somehow delete one of the addresses and then put it back to a file...anything that can one by one delete the addresses so I know that it all has worked as there would be no email addresses left in the 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
After looking all over the place and finding codes in vb and in php I even had asked several people on other boards but none of them knew how to do it I say the best way to learn this .asp .aspx junk is to DO IT yourself although Ive scripted in the past with the mIRC client which is why I know programming and html but if anyone is looking for the code this is how its done Code:
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
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