File Name

Hi there,

how can I extract the year out of a single cell like “07.2018” and name the file like “2018_Example-Q1-Q2.xlsx”. In the file name only the year should be variable. (In the column where the cell is, there are also other data.

All the best :sunny:

Hi!

String Manipulation node would be an answer for creating “yyyy_any_text” format. Then use Table Row to Variable node to create a flow variable from it which you will use in your Excel Writer/Appender as file name :wink:

Br,
Ivan