M-Files is a 2025 Gartner Peer Insights Customers' Choice for Document Management
️️➡️Download the report!

Options
  • Locked Locked
  • Replies 6 replies
  • Subscribers 9 subscribers
  • Views 696 views
  • Users 0 members are here
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Text Analytics - PDF - Regex Issue

pcaldwell
Hey

I'm new to Regex but working my way through,
I have the correct syntax i need to find certain words when testing with a text file, but when i use it on the PDF it will not work,
Must be an issue with Columns or spacing etc.

i was wondering if someone could point me in the right direction of how i could get it to find the Value.
In the attachment bellow, it would be '0.27'

{
    "targetName": " Total Ex GST",
    "documentContentPattern": "(Total Charges Excluding GST:\s*\$(?<value>(\d{1,3}(\,\d{3})*|(\d+))(\.\d{2})?$))",
    "Comment": "",
    "enabled": true
}


Also, could i get this to map to a Property Field that was set to Number (real)

Parents
  • If - like in your case - you have a predefined text with spaces in it, then you can just include those spaces in the text as shown in your bottom example.
    \s will match any "white-space" character which can be space, tab, carriage return or new line etc.
    \s* will match zero or more characters, \s+ will match 1 or more characters.
Reply
  • If - like in your case - you have a predefined text with spaces in it, then you can just include those spaces in the text as shown in your bottom example.
    \s will match any "white-space" character which can be space, tab, carriage return or new line etc.
    \s* will match zero or more characters, \s+ will match 1 or more characters.
Children
No Data
M-Files
M-Files Support


© 2025 M-Files, All Rights Reserved.