How to create a flow variable based on an existing one to handle file paths

Hi all,

I have the flow variable dataURL attached to the FileReader node - example file:/c:/users/me/input.csv

I want to create a new flow variable to feed into the Excel Sheet Appender file path - example c:\users\me\output.xlsx

Basically I want to use the same directory to read from and write to

Any tips ?




Hi Tev

You can use a Java Edit Variable node to edit it.

I would create a directory flow variable, and then use it to create the input and the output.

I've attached an example. By the say, the "\" needs to be escaped in java, hence the "\\" used in the java edit node. 



Thanks a lot for the example.