This worked!! Thank you so much.
You have been so helpful! Do you have any tips on how to automate drop-down menus? I need the database to choose the correct option in the drop down menu that matches the extracted text.
I have tried this activity, I am just unsure if I can use it without quoting the exact text? - Each pdf document will have a different extracted value, so how do I indicate it to choose whatever the extracted value is/value stored in the variable?
I have figured out all String drop downs using the type into activity, but I am having trouble with the numeric values, and am unsure how to select these in the drop down using my stored variable, any ideas?
Hi there,
Going back to extracting these dates, how would I extract each individual part of the date? (For example: extracting just the “03” from the in service date: “03/10/2020”
And then same for the day and year,
Anything helps!! Thank you!!
Sorry to Interrupt, Even i have some question on regex
“05/02/2019 91640.00 52974.00 38666.00 2342299.00”
This is my pattern and have multiple value of same pattern, i want to scrape this specific value “38666.0”.
Even i applied regex (?<=\d{2}/\d{2}/\d{4}\s\d*.\d*\s\d*.\d*\s)(.)(?=\s\d.\d*) and it got worked also.
can i get any alternative simple regex pattern
Assign (Decimal) result = CDec(Regex.Match(myText, pattern).Groups("third").Value)
I saved it on regex101 for you to examine. The right pane will help you on your journey. I mostly learn throught Perl and Python documentation and by practice (try parsing urls, its quite easy). Here is a link but I didn’t use it (Regular Expression Tutorial - Learn How to Use Regular Expressions)