How to change default CSV delimiter when running via command line with Toad
Hi all,
I'm using the FastReport 4.6.5 that comes with Quest Toad for Oracle. It is launched from Toad via the Reports Manager. The result is a .fr3 file that contains the report definition.
To run the report as a cron job, I created a vbscript that runs Toad which reads in the SQL statement, the .fr3 file and a couple of other parameters which instructs Toad to save the result as a .csv file and close itself afterwards.
However, I find that I can only choose the CSV delimiter through the following path:
File -> Preview -> Export to CSV -> Export properties -> Separator. The default separator is ';' and after you change it, you can save the resulting CSV file, but cannot save the changed separator into the .fr3 file.
Does anyone know how to change this default CSV delimiter, or better yet, save the delimiter change to the current .fr3 file?
Many thanks.
I'm using the FastReport 4.6.5 that comes with Quest Toad for Oracle. It is launched from Toad via the Reports Manager. The result is a .fr3 file that contains the report definition.
To run the report as a cron job, I created a vbscript that runs Toad which reads in the SQL statement, the .fr3 file and a couple of other parameters which instructs Toad to save the result as a .csv file and close itself afterwards.
However, I find that I can only choose the CSV delimiter through the following path:
File -> Preview -> Export to CSV -> Export properties -> Separator. The default separator is ';' and after you change it, you can save the resulting CSV file, but cannot save the changed separator into the .fr3 file.
Does anyone know how to change this default CSV delimiter, or better yet, save the delimiter change to the current .fr3 file?
Many thanks.