Skip to main content
Question

Filter by Wildcard

  • November 8, 2016
  • 3 replies
  • 46 views

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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

redgeographics
Celebrity
Forum|alt.badge.img+62

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


itay
Supporter
Forum|alt.badge.img+18
  • Supporter
  • November 8, 2016

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


erik_jan
Contributor
Forum|alt.badge.img+26
  • Contributor
  • November 8, 2016

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