[jira] [Resolved] (TIKA-3042) Date format extraction problem in XLS/XLSX

["Tim Allison (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TIKA-3042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tim Allison resolved TIKA-3042.
-------------------------------
    Fix Version/s: 1.24
       Resolution: Fixed

> Date format extraction problem in XLS/XLSX
> ------------------------------------------
>
>                 Key: TIKA-3042
>                 URL: https://issues.apache.org/jira/browse/TIKA-3042
>             Project: Tika
>          Issue Type: Task
>            Reporter: Zoltan Farago
>            Assignee: Tim Allison
>            Priority: Major
>             Fix For: 1.24
>
>         Attachments: exceldatum.xlsx
>
>
> 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. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)