[TIKA-3042] Date format extraction problem in XLS/XLSX

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.24
• Assignee: Tim Allison
• Reporter: Zoltan Farago
• Created: 13/Feb/20 12:15
• Updated: 03/Mar/20 17:10
• Resolved: 02/Mar/20 23:10

Description

Currently TIKA/ManifoldCF 2.10 extracts dates from the attached file tis way:

2018.05.10 -> 10/05/18
2002.02.02 -> 2/2/2

We need this format:

2018.05.10 -> 2018-05-10

2002.02.02 -> 2002-02-02

This occurs only when the field type is date. When the field type is text then the output is fine.

 

Please help us with a recommendation with any settings in the pipeline (Tika configs, excel setting, OS local settings, etc.), or provide a fix.