Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for Search instead for Did you mean:I have a doubt in extracting data from invoice. I have to extract the few data such sold by, billing address etc., from invoice using regex it would be helpful if someone can explain me how should I do it using Utility-Strings ?
Please can you provide some more information on your use case?
e.g.
- What is the current data format? Excel, PDF,etc
- How are you getting the data into Blue Prism?
- How do you identify each field of data?
It is in pdf form, amazon invoice and I am using clipboard activity to copy it in a data item in blueprism from where I need to use regex for extracting the data such as sold by, billing address and then store it in a collection and write it in an excel sheet
I previously faced a similar challenge and we had a bit of a work around.
We copy and pasted the pdf fields into a blank Excel spreadsheet. Each value will go into column A and separated by rows. This was relatively well structured, so you could find value X in the row after field X consistently.
Though the long term solution might be to look at getting Decipher.