Wildcard is the symbol that you can use to find any matching file or to replace the date.

1. Symbol that can replace with * to find any match file name related with. 

    Example: Sample*.csv - will match the file name with all the latest file first 

2. Symbol that can replace with the date to generate the file daily. 

    Example: /feed/sample_%Y_%m_%d_*.csv to /feed/sample_2017_05_09_.csv

3. Wildcard can be used in certain part such as FTP file name represent, filter section, and any part that support wildcard. 

Below are the table to show the differentiate between today date, yesterday date and previous year to relate the symbol. 

To view the accurate format of date, please do open your feed file via notes or notepad so that can see it clearly. If open via excel, it could change some of the value formatting such as numbers and dates. 


Today Date

Yesterday Date

Previous Month

Previous Year

Symbol

Example

Symbol

Example

Symbol

Example

Symbol 

Example

%d

01..31 (Date with zero)

%{d-}

01..31 (Date with zero)

%m-

01..12 (Month with zero)

%Y-

1995, 2009, 2017

%-d

1..31 (Date without zero)




%b-

Jan

%y-

00..99 (Year last 2 digits)

%m

01..12 (Month with zero)

%^b-

JAN


%-m

1..12 (Month without zero)


%b

Jan

%^b

JAN

%Y

1995, 2009, 2017

%y

00..99 (Year last 2 digits)

%H

00..23 (in 24 hours format)