The regular expression parser doesn't cope with library regexp for thousands separator UK amounts. This expression ([0-9] {1-3}","[0-9] {1-9}"."[0-9]{2}) does not pick up amounts without thousands separators and the fractions sample in the help file doesn't get the amount after the decimal place. I've tried ORing the above expression with one for no thousands separators but the parser rejects it as invalid
Flexilayout character string element. Need Regexp for thousands separators Answered
Was this article helpful?
0 out of 0 found this helpful
Comments
2 comments
Hello,
The better approach to capturing strings such as money amounts would be to use alphabets to select the strings of desired format, not the regular expressions (as regular expressions are too strict and fail when there are OCR faults).
In addition to setting up of allowed alphabet, you may also set up the prohibited alphabet (having 0 as characters percentage count).
The string format can also be regulated by "Character count" and "Word count" expressions.
Thanks again
Please sign in to leave a comment.