Based on a complete visual inspection of the interior and exterior areas of the subject property, defined scope of work, statement of assumptions and limiting
conditions, and appraiser’s certification, my (our) opinion of the market value, as defined, of the real property that is the subject of this reportis
as of 11/18/2021
which is the date of inspection and the effective date of this appraisal.
From the above string I need to extract only the amount using regex how can we do it.
Try out this regex ((?<=$)[\d,]+)
Update us whether you got solution or not
It’s not working for me and the amount we need to extract will be 350,000 please ignore the “$”
It worked but in the whole string it’s picking up the “,” at index(0) can we get the number at index
I want to know whether the amount value is static or dynamic
Try like below. Thanks.
Resultmatch = System.Text.RegularExpressions.Matches(inputstring,"([0-9]+)")
Can you try this regex
It’s separating the number between “,”
I think below will work. Pls check
You could use matches activity and first index. Thanks.
Actually I am reading a PDF with OCR after reading the PDF I am getting the out put in different format each time as you can see above some times $ will come infront of Amount and sometimes"," comes at last and some times “[space]”
If you can help me figure this out I am grateful.
Can you share us extracted text files so that only we could give a solution as you expected
Try this regex
TEST.txt (1.5 KB)
TEXT1 and TEXT2 and TEXT3 and TEXT 4 are extracted from 4 different reports
It’s working Thankyou so much!
Or You try this expression also
it will exactly extract all amount for all different extractions
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.