Question

Filter by Wildcard

  • 8 November 2016
  • 3 replies
  • 10 views
K

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% ?

3 replies

redgeographics
Rank
Userlevel 5
Badge +25

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

itay
Rank
Badge +16

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

erik_jan
Rank
Userlevel 2
Badge +16

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

Reply


Community Stats

28,707
Posts
109,480
Replies
36,553
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.