Wildcard and Dynamic Date

Modified on Wed, 15 Feb 2023 at 11:48 AM

The 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 files first

2. Symbol that can replace 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 parts such as FTP file name representation, filter section, and any part that support wildcard.

Below is the table to show the differences between today's date, yesterday's date, and the 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)