Extract Invoice data using regex

[LokeshRaj]

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 ?

[Ben.Lyons1]

Hi Lokesh,

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?

Thanks

Ben

[LokeshRaj]

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

[Ben.Lyons1]

Hi Lokesh,

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.

Thanks

Ben

[LokeshRaj]

Thanks Ben, I tried installing Decipher, but I'm getting some error in installing it. So I have to use the regex for extracting the data from the invoice.

Thanks,

Lokesh

[Ben.Lyons1]

Hi Lokesh,

If you're having trouble installing Decipher, we'd be more than happy to help get you started.

Do you have a Decipher enabled license for Blue Prism?

If you're interested in learning more, please reach out to your account manager.

Thanks

Ben

[LokeshRaj]

Hi Ben,
I am currently using Blue prism Version 7 which have decipher IDP enabled, but I'm getting trouble because my decipher server is not running and I don't know the exact reason for the issue. But I would love to talk with your account manager for this issue soon.

Thanks,

Lokesh

[Ben.Lyons1]

If you've managed to get that far, our customer support team might be able to help you get it going. Please raise a support ticket and they can help you troubleshoot.

Thanks