Hello All,
Has any one done sorting of columns in .CSV file?
I am aware that it is possible but if any one has done it in ASP please help me with a code.
Cyrus

What do you mean by sorting in a CSV? Do you mean sorting a recordset before you write the CSV? Or reading in a CSV and then sorting it, and writing it out to the browser?

I have clearly mentioned it !!!!
I want to sort based on a column in a csv file

cyrus

Well cyrus....since you clearly mentioned what you wanted to do, why don't you go and do it? Seppuku asked a clarifying question and you jumped all over him...way to get an answer.

Help with code? Why would anyone help you when you snap back at them. I have rearranged CSV using ASP and VBS\JS, so yes it is possible. But with your attitude here is the help I will give you:

1) Learn VBS\JS and FSO
2) Don't snap at people when they ask a question of you, all he wanted was to clarify something
3) Use Excel if you can't figure it out

That is more help then you deserve.

Originally posted by cyrus
Hello All,
Has any one done sorting of columns in .CSV file?
I am aware that it is possible but if any one has done it in ASP please help me with a code.

Cyrus

Well you can use a .csv file as a recordset just as you can a database and then control the sorting with your SQL statement.

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForTextFiles

Originally posted by Bullschmidt
Well you can use a .csv file as a recordset just as you can a database and then control the sorting with your SQL statement.

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForTextFiles

Thanx
Ya i can do that.
But what i am doing is reading each line and then validating and then seeking a record in the databse depending on the value of field.
As i don't want to seek in database if there is the same value I want the csv to be sorted