Hello @Pal_Patel
For the filename, you can refer to the current date using this:
System.DateTime.Now.ToString(“yyyyMMMdd”)
See here for more about Datetime:
To convert your text file into a CSV file, try these steps:
- Insert a ‘Read Text File’ activities. Save the output as “StringTXT”
- Insert ‘Generate datatable’ activity and use “StringTXT” as the input and update the delimiter (comma or pipe etc). This will convert the text into a datatable variable. Save the output datatable as “DtResult”
- Insert a ‘Write CSV’ activity and insert “DtResult” the filepath.
Here is a video tutorial also:
Hopefully this helps,
Cheers
Steve