File name variables

<< Click to Display Table of Contents >>

Navigation:  Reference >

File name variables

You can dynamically change the name of an output file based on input file names using file name variables. For example, if the input file with alias orders has file name orders_2022_04_07.csv, then setting the output filename to output_{orders.fname}.csv will write to output_orders_2022_04_07.csv.

 

Output variables

Meaning

Example

{<input alias>.fname}

The name of the input file being processed in the column with the corresponding alias.

If the input with alias orders is using file C:\Users\andy\Documents\orders_2020.csv then {orders.fname} is replaced with orders_2020.

{<input alias>.ext}

The extension of the input file being processed in the column with the corresponding alias. Does not include the '.'.

If the input with alias orders is using file C:\Users\andy\Documents\orders_2020.csv then {orders.ext} is replaced with value csv.

{<input alias>.sheet}

The sheet of the input file being processed in the column with the corresponding alias (Excel only).

If the input with alias orders is using file C:\Users\andy\Documents\orders_2020.xlsx with sheet Sheet1 then {orders.sheet} is replaced with value Sheet1.

{<input alias>}

The name of the input file (plus an underscore and the sheet name, if an Excel file) being processed in the column with the corresponding alias.

If the input with alias orders is using file C:\Users\andy\Documents\orders_2020.csv then {orders} is replaced with value orders_2020.

If the input with alias orders is using file C:\Users\andy\Documents\orders_2020.xlsx with sheet Sheet1 then {orders} is replaced with value orders_2020_Sheet1.

{date}

Date processing was carried out in year_month_day format

2020_04_18

{time}

Time processing was carried out in hours_minutes_seconds_milliseconds format

15_21_56_599

{datetime}

Date/Time processing was carried out in year_month_day_hours_minutes_seconds_milliseconds format

2020_04_18_15_21_56_599

 

File name variables can be used for output file names set in the Right pane, in batch processing or through command line arguments.