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.

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/...erForTextFiles

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