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:

PatternMeaning

*

Matches everything

?

Matches anything

[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'.

Last updated