Regular Expression - M-FIles Text Analytics

Question

Hi, 
 
 I'm not a developer, but I'm trying to configure the M-Files Text Analytics. :). In a document (Contract) is a text Contract No. After that text is a number. A want to add that number to a property definition. So, basically, I want to add a value after the "Contract No." and before the first space. 
 
 I've been searching on the internet for the last 3 hours, but I have nothing to show 
 Any help would be appreciated. 
 Below is the script from the MF Text Analytics: 
 { "targetName": "ContractNo", "documentContentPattern": "THIS IS WHERE I WANT TO PUT THE REGULAR EXPRESSION", "comment": "PArtnerjeva &scaron;tevilka pogodbe", "enabled": true, "forceSetValue": true } 
 
 BTW, is that even doable in MF Text Analytics? 
 
 Best, Uros

bright-ideas.dk · Accepted Answer

Hi Uros, 
 It is certainly doable. Something like this should work for you: 
 "(\bContract\sNo\.\s*(?<value>\d{5}\b))", 
 The {5} indicates the number of digits. Change it to fit your situation or replace '{5}' with '+' , if Contract No. does not have a fixed number of digits. 
 Checkout http://www.ultrapico.com/expresso.htm for a tool to test your expressions against real world text samples. Remember that you need to double each backslash in M-Files because the expression is placed in JSON code. There are plenty of websites with explanations on regex, so folks like us can learn the basics relatively fast, if we set our mind to it 
 RB, Karl

bright-ideas.dk · Answer

The primary trick on dates is to add a "normalizeas" line. You should nomalize to the locale used on your M-files server. Here is a setting, that I use a lot and that will recognize a wide range of date formats. { "targetName": "Date_dd-mm-yyyy", "documentContentPattern": "(?(\b(?([0-3]?[0-9]))(?:[-/\.])(?([0-1]?[0-9]))(?:[-/\.])(?([0-9]{2,4}))\b)|(\b(?([0-9]{2,4}))(?:[-/\.])(?([0-1]?[0-9]))(?:[-/\.])(?([0-3]?[0-9]))\b))", "comment": "Date in (d)d-(m)m-(yy)yy short or long format", "normalizeAs": "Date(da-DK)", "enabled": true }

Joonas Linkola · Answer

The Text Analytics configuration guide has further information on the normalizeAs option on pages 12-14 under "Converting text value metadata suggestions to another data type".

Regular Expression - M-FIles Text Analytics

Top Replies