Troubleshooting
Problem
Unable to search for locale-specific formatted date in an Excel file whose text is extracted by using Outside-In version 8.5.5 or earlier on Linux.
Symptom
Steps to reproduce:
1. On a Content Platform Engine (CPE) Linux system, add an Excel document with a locale-based date value in Brazilian format dd/mm/yyyy (for example 24/2/2006) and index it. Locale-specific date values are date formats that start with an * in Microsoft excel.
2. Try to search for the document with ACCE.
1st query with the Brazil date time format:
SELECT d.This FROM Document d INNER JOIN ContentSearch c ON d.This = c.QueriedObject WHERE CONTAINS(d.*,'24/2')
Result: No document was retrieved
2nd query with the US date time format:
SELECT d.This FROM Document d INNER JOIN ContentSearch c ON d.This = c.QueriedObject WHERE CONTAINS(d.*,'2/24')
Result: One document retrieved.On Linux systems, locale-based date formats are extracted incorrectly.
On Windows systems, locale-based date formats are extracted correctly.
On Windows systems, locale-based date formats are extracted correctly.
Note: Non-locale based date formats (also known as fixed date formats) are extracted correctly. Such data formats are not marked with an * in Microsoft Excel.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSNVNV","label":"FileNet Content Manager"},"ARM Category":[{"code":"a8m0z000000bpTwAAI","label":"CBR"},{"code":"a8m0z000000boPjAAI","label":"CSS"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
28 April 2025
UID
ibm16537286