SS&C Blue Prism Community

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: Extract Invoice data using regex

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 ?

Thumbnail of Blue Prism RPA (Legacy)

Blue Prism RPA (Legacy) Blue Prism 7 REPLIES 7

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?

Ben Lyons
Principal Product Specialist - Decipher
SS&C Blue Prism
UK based

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.