Text analytics - FilePathPattern to a value list

Hi Team,

I've spent a lot longer on this that I'd care to admit.

I have a requirement to extract a specific folder name from the FilePathPattern and have this set the "Quarter Ending" property which is a Value List containing 4 dates:

31 Mar, 30 Jun, 30 Sep, 31 Dec

And the FilePath is in the format \\server\share\31 Dec\scanned_document.pdf

I have my regex that is retrieving the date element from the FilePath correctly (tested by having this add to a standard Text property. But when I configure this to return the value to the "Quarter Ending" property (which is a Value List) nothing happens.

1st Question, is this even possible?

2nd Question, if so should Text Analytics be able to do this, or should I also require Matcher?

3rd Question, why doesn't it work? Slight smile

Any assistance would be appreciated. I've been stuck on this for weeks.

Parents Reply Children
  • Thanks Joonas, 

    Our M-Files Sales engineer confirmed the same. And Text Analytics cannot be used to populate a value list based property :(


    We have come up with a dirty work around. I'm using Text Analytics to get the data we need and fill in a temporary text property (hidden from the metadata card) and then use PropertyCalculator to set the correct value in the value list based on the text in the hidden property. 

    Maybe this might help someone else one day :)