Skip to main content
  • EN

I have a date attribute in the format %Y%m%d%H%M%S. I want to use everything in 2016, so how can I create a wildcard similar to 2016% ?

You can use the option begins with in the Tester or Testfilter, or a StringSearcher and then use ^2016 as the regular expression.

If your data is in a database you could use the underlaying database syntax to request only the 2016 data

Or you could use the SubstringExtractor to create a YEAR attribute (Substring 0 - 3) and use that in the AttributeFilter transformer.

Reply


Community Stats

30,126
Posts
114,351
Replies
37,758
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.