Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Location
    Pune
    Posts
    59

    Unanswered: Sorting Columns in .CSV File

    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

  2. #2
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    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?
    That which does not kill me postpones the inevitable.

  3. #3
    Join Date
    Oct 2003
    Location
    Pune
    Posts
    59
    I have clearly mentioned it !!!!
    I want to sort based on a column in a csv file


    cyrus

  4. #4
    Join Date
    Mar 2003
    Posts
    8
    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.

  5. #5
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032

    Re: Sorting Columns in .CSV File

    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/...erForTextFiles
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

  6. #6
    Join Date
    Oct 2003
    Location
    Pune
    Posts
    59

    Re: Sorting Columns in .CSV File

    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/...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
    Cyrus
    Finding ways for solution

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •