Description
When running tests using the ExcelReader and inferring the schema, even though the date pattern 'M/d/yy' was specified (which per this post should allow single digit months), dates like '1/1/18' are not inferred to be DATE:M/d/yy but rather STRING. The source for this is
org.apache.nifi.util.text.RegexDateTimeMatcher whose regular expression for months requires two digits. It should be relaxed to allow for one or two digits.
Attachments
Issue Links
- Discovered while testing
-
NIFI-12491 Add Use Starting Row Strategy to Excel Reader
- Resolved
- relates to
-
NIFI-13565 Record Date Time Properties should mention DateTimeFormatter instead of SimpleDateFormat
- Resolved
-
NIFI-13569 Improve TestRegexDateTimeMatcher.java by making it JUnit 5 Parameterized Test
- Resolved
- links to