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
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
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
Br,
Ivan