topic Re: Extract Invoice data using regex in Product Forum

Extract Invoice data using regex

LokeshRaj — Wed, 07 Jul 2021 06:01:08 GMT

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 ?

Re: Extract Invoice data using regex

Ben.Lyons1 — Wed, 07 Jul 2021 07:47:06 GMT

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

Re: Extract Invoice data using regex

LokeshRaj — Wed, 07 Jul 2021 08:41:19 GMT

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

Re: Extract Invoice data using regex

Ben.Lyons1 — Wed, 07 Jul 2021 09:23:45 GMT

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

Re: Extract Invoice data using regex

LokeshRaj — Wed, 07 Jul 2021 09:30:56 GMT

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

Re: Extract Invoice data using regex

Ben.Lyons1 — Wed, 07 Jul 2021 09:35:51 GMT

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

Re: Extract Invoice data using regex

LokeshRaj — Wed, 07 Jul 2021 09:43:26 GMT

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

Re: Extract Invoice data using regex

Ben.Lyons1 — Wed, 07 Jul 2021 09:53:22 GMT

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