Frequently Asked Questions
Frequently Asked Questions
How to use date in Text Analytics in IML?
Posted by Hannu Anttila (M-Files) on 27 March 2019 10:34 AM
By default custom rules gives string type of proposals in M-Files Text Analytics. For dates this can be changed by adding configuration property like the following:
 
"normalizeAs": "Date(fi-FI;d.M.yyyy)",
 
If the string to be normalized already happens to be in a format known to some predefined .net culture, then only that culture name is sufficient, as in
 
"normalizeAs": "Date(fi-FI)"
 
This would work e.g. for Danish date in the format dd-MM-yyyy, e.g. 31-12-2018:
 
{
"targetName": "Date2",
"documentContentPattern": "(?<value>([0-3][0-9]-[0-1][0-9]-[0-9]{4}))",
"comment": "Different date format",
"enabled": true,
"normalizeAs": "Date(da-DK)"
}
 
You must set this directly in "Advanced" tab in the configuration.
 
List of Standard culture names can be found at here:
 

https://msdn.microsoft.com/en-us/library/ky2chs3h(v=vs.110).aspx

https://docs.microsoft.com/en-us/openspecs/windows_protocols/ms-lcid/a9eac961-e77d-41a6-90a5-ce1a8b0cdb9c

 
(0 vote(s))
This article was helpful
This article was not helpful

Help Desk Software by Kayako case