Export to unique file name for delimited text file: txt

[rmcvicar]

I need to run a SQL Script to generate the content for a delimited text file that has a pipe delimiteder.

The problem is the file name which has to be unique: DSI_YYYYMMDDhhmmss.txt

Is this possible with Easymorph?

rmcvicar

[dgudkov]

Hi Ronald,

Using a dynamically generated output file name is a frequent question in this forum. Here is one of the topics: Export File Using Parameters for File Name and Path

Also:

How to add current date to file name

Here is a simple example showing how to add the current date to an exported file name. The file name is obtained using a calculated parameter with the following expression: 'result' & format(today(), 'dd-MM-yyyy') & '.csv' which evaluated (on the date of this post) to result16-04-2019.csv Then the parameter is used in the export action instead of a hardcoded file name. filename-timestamp.morph (1.6 KB)

CSV export with timestamp

Hi, I currently setup an export to CSV format, but if I apply a parameter such as timestamp for the file name, it does not work, it exports as *.TXT format. Is there any special configuration in order to export as CSV? Thank you very much.

How to add date & time to exported file name

I need to add the date and time to the same file name every time I run a project using the “Export into delimited text file” action. I have succeeded in adding just the date to the filename with: ’G:\My Drive\Finance\MyFileName ’ & format(today(), ‘yyyy-MM-dd’) & '.csv’ as a parameter the result is a file with the name: MyFileName 2019-10-15.csv but when I change that parameter to: ’G:\My Drive\Finance\MyFileName ’ & format(now(), ‘yyyy-MM-dd HH:mm’) & '.csv’ I get “The given path’s forma…