still looking for help

[Dreadnort]

Is there a way that an asp script can look in a csv file and count the number of rows or number of entries found under a colum

[cmelnick]

There is no built in method that will automatically parse a text file. It wouldn't be terribly difficult to write your own parsing methods. You could use something like this:


Dim strPath, oFileSys, oCSVFile, myLine, myRecord, count
strPath = Server.MapPath("/your/database.csv")
Set oFileSys = Server.CreateObject("Scripting.FileSystemObject")
Set oCSVFile = oFileSys.OpenTextFile(strPath, 1, False)

count = 0
Do Until oCSVFile.EOF

myLine = oCSVFile.ReadLine
myRecord = Split(myLine, ",")
' This will give you an array with your table values in
' myRecord(0), myRecord(1)...etc
' UBound(myRecord) will give you number of columns
count = count + 1

Loop

' count will give you number of rows.

oCSBFile.Close


(p.s. just typed this up, so I probably made a mistake or two...just an example)

[Dreadnort]

i will take a look and see what i can do

thanks

[cmelnick]

You're welcome...if you need more help, I can take a look at your CSV file and help you with exact code. Just let me know. Send me an e-mail to cmelnick (at) bigfoot (dot) com if I am not on the board.

[cmelnick]

Doh!

Sorry, the line:
Do Until oCSVFile.EOF
should be
Do Until oCSVFile.AtEndOfStream

Sorry. Been working w/ ADODB too much :D Forgot how to parse a text file...