A common requirement when using Inaport to import text files is to rename the files after processing. This allows an external process (e.g. mainframe) to continuously drop in text files, for Inaport to process on a scheduled basis.
The Inaport text connector provides two options for handling a file after it has been processed:
-
Change the extension of the file
-
Move the file to a new directory
These options may be combined, so it is possible to change the extension to ".done" and move the file to a directory "Processed", for example.
Inaport also supports using expressions in the "Change extension" text box. This allows you to include a time stamp in the new name. For example, the following expression can be put in the text box:
"." & nowstr("yyyyMMddTHH_mm_ss") & ".done"
If the current date and time is 24 October 2008 @ 16:46:00, this will change the extension of the file to:
".20081024T16_47_00.done"
The expression used can be any valid Inaport expression that produces a string that is legal to include in a file name.