Hi,
My application creates a CSV file and enters table data into it. The problem is - when csv file is created by Delphi it will have all the columns format set to GENERAL. Because of this the leading 0's are discarded. To resolve this I amended the code so that I have a pre-created file with column formatting set. Then in the application I copy this file and open it by issuing Delphi file command - append(). The Delphi is opening file correctly but is not writing the data into the csv file opened in this way. While if I amend the file type to .txt it does write the data. Can anyone provide inputs to resolve this issue. Either
1. How to set column formatting of a .csv file from delphi. [The application do write the data when file is created and opened with rewrite() command] OR
2. How I can append to a .csv file which I am copying from a pre-created .csv having the formatting set.
Thanks.