Wildcards

<< Click to Display Table of Contents >>

Navigation:  Reference >

Wildcards

Wildcards are used to match to match file and sheet names, for example when inputting files from a folder. The following syntax is supported:

 

Wildcard

Description

*

matches zero or more characters

?

matches exactly one character

[abc]

matches one character from the set

[a-z]

matches one character from the range

 

For example:

a* matches names that start with 'a'

*.csv matches names that end in '.csv'

??.csv matches names with a 2 character stem

[01]*.json matches names that start with '0' or '1' and end in '.json'

[0-9]*.json matches names that start with a digit and end in '.json'