Wildcard Names

For external sources, you can use wildcard names when selecting the source data. This is used where the name of the source file is dynamic e.g. Account_Import_TODAYS_DATE.csv.

Using wildcards you can let Dataimporter search through your data source for matching CSV files, and choose the latest file to be used for the job:

The following pattern matches are defined:

Pattern	Meaning
*	Matches zero or more characters
?	Matches exactly one character
[seq]	Matches any character in a sequence
[!seq]	Matches any character not in a sequence

Example

Using the pattern Account_Import*.csv would select the following file in the SFTP Server:

Although the File is named with an earlier date, Dataimporter will always take the latest modified file that matches the Wildcard pattern.

If no file can be found using the pattern then you will receive a message 'No File Found'.

Examples

1. Using ?:

   • Pattern: file?.csv

   • Matches:

     • file1.csv

     • fileA.csv

     • file_.csv

   • Does not match:

     • file.csv (no character in place of ?)

     • file12.csv (two characters in place of ?)

     • files.csv (two extra letters in place of ?)

2. Using *:

   • Pattern: data*.csv

   • Matches:

     • data.csv (zero characters after data)

     • data1.csv

     • data_set.csv

     • dataXYZ.csv

   • Does not match:

     • mydata.csv (does not start with data)

     • data.json (different file extension)