Hw to use file name from for each

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

1 Like