Wildcard and Dynamic Date

Modified on Tue, 05 Sep 2023 at 11:24 PM

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 or Download URL file name representation, filter section, and any part that supports 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 the date, please open your feed file via notes or notepad so that can see it clearly. If opened 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)

 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article