Search
Welcome to M-Files Empower – our new support experience. We'd love to hear what you think!Give feedback

Last updated on 28 February 2021

Admin
M-Files Text Analytics

Overview

 

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.

Reference Documents

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

Still need help?