Start a new topic
Answered

FileWait/Move/Copy: FileInclude with space

We have noticed that it is not possible in a FileWait/Move/Copy to search for a file containing spaces via fileInclude parameter. Suppose, if we want to search for the files("File Toto1.txt","File Toto2.txt","File Toto3.txt") by using fileInclude = "File*.txt" we will get 3 files, on the other hand by using fileInclude = "File Toto*.txt" XDI will not find any file.


Therefore, space is not allowed in the fileInclude parameter. Can we replace space by something else?



Best Answer

We have two solution:

==>Use "?" which will only match one character rather than "*".

==>Drag a schema on the Filewait action to store the name of the files in the "ind_session_file_op_lst" technical table with all the other details concerning the files found by the action. This table is created and used automatically in the schema dragged onto the action. We can therefore imagine a process with a FileWait action which will retrieve the list of files to be processed and then a SqlOperation action as the source of a DirectBind to exploit the information in this table by filtering on the file names. For instance:

1 Comment

Answer

We have two solution:

==>Use "?" which will only match one character rather than "*".

==>Drag a schema on the Filewait action to store the name of the files in the "ind_session_file_op_lst" technical table with all the other details concerning the files found by the action. This table is created and used automatically in the schema dragged onto the action. We can therefore imagine a process with a FileWait action which will retrieve the list of files to be processed and then a SqlOperation action as the source of a DirectBind to exploit the information in this table by filtering on the file names. For instance:

Login to post a comment