In the READ adapter:
I am creating .fhd to import from Folder1 and export to Folder2.
Each day, in Folder1 is a file with a different name - time stamp. In the Filename [TextFileAdapter READ] I have tried both * and % as wildcards but are not working. Can I create .fhd which when scheduled to auto-run daily will pick-up any FORECASTyyyymmdd.txt file. Should FORECAST*.txt work or something else?
In the WRITE adapter, in Filename, I would like to have a code or something so .fhd exports data to a file with an name as the READ file but with a prefix FH, for example: If READ file is=>FORECAST20150331.txt so WRITE file should be=> FH_FORECAST20150331.txt
public object DoWork()
// adopt the CSV file name from the READ Side!
TextFileAdapter adapter = (TextFileAdapter)AdapterRead;
// get file name without path
string filename = Path.GetFileName(adapter.Filename);
// return the file name
The script returns just the CSV filename without the path. With the
String Append Heater
you have to add a prefix “FH_” to this result and afterward set this value to a
by using the
Set Parameter Heater
. This Paramater (e.g. $FILENAME_WRITE$) you have to use in TextFile Adapter for the CSV output file name.
I’ve made a simple example for this, please have a look to the example adopt-csv-filename.zip