#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2012
    Posts
    2
    Rep Power
    0

    Exclamation Is it possible to use Parse Record procedure on 5 CSV files


    I have an unusual request / problem:
    - open 5 csv files,
    - calculate the average value for each cell,
    - save one csv file with new values, which has the same structure as the five selected.
    Is it possible to calculate the average of the matrix / Each cell separately in Borland Delphi 7?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2012
    Posts
    151
    Rep Power
    3
    Yes, it is possible. Use TStringList instances to help you read in and parse csv files, and also to write the new csv file.
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2008
    Posts
    350
    Rep Power
    7
    Another option would be to automate the process with Excel (only possible if Excel is installed on your and your user's computer)

    You can look here for an example of automating excel from within Delphi:

    http://support.microsoft.com/kb/231614

IMN logo majestic logo threadwatch logo seochat tools logo