Extract line from pdf with regex

[joseantonio (RPASOFT)]

good morning, I’m trying to regex the following string: 104.99 0.00 0.00 0.00 0.00

from the text that I put below, but I can’t find the way or for some reason I can’t make it work, what can I do?

Base Imponible +LPI IVA Cuota IVA Recargo Cuota Recargo Importe Total: 104,99 EUR

104,99 0,00 0,00 0,00 0,00

Forma de pago: RECIBO DOMICILIADO A 20 D-B2B Vencimientos: 26/11/2020 104,99 EUR

[mohammedsameer.ali1 (Mohammed sameer Ali)]

Hi Joseantonio,

You can use (?<=EUR)\s*\d.+ Here you have to keep in mind that EUR is used as anchor point. If it is changing paste that data to find a better regex.

[joseantonio (RPASOFT)]

Thanks for your help, I have managed to isolate the content I want by groups, my question now is the following, for example if I wanted only the third group, what would the expression be? I attach an example of regex to capture that line by groups

(?<=EUR)\n\n(.?(?=\s))\s(.?(?=\s))\s(.?(?=\s))\s(.?(?=\s))\s(.*?(?=\s))

link https://regex101.com/r/cO8lqs/23674

[Steven_McKeering]

Hello

To get group 3.

Try using an assign Activity.

YourVariable = REGEXRESULT(0).Groups(3).Tostring

Update capital letters from Matches result.

If yo I want to learn Regex - check out my Regex Megapost

Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more

THE PURPOSE OF THIS POST IS TO HELP NEW REGEX USERS If you need help with Regex be sure to provide in your post, a Sample, the Output and the Pattern (as much as you know). CONTENTS: Section : I need a Regex Pattern ASAP! - My first Regex Post Section : Regex samples that you can use! Section : I need help applying regex in UiPath Section : Regex Matches and Groups Section : Le…

[joseantonio (RPASOFT)]

@Steven_McKeering

REGEXRESULT(0).Groups(3).Tostring

thanks

I usually use regex to extract the information and attach it to the datatable, but this is the first time that I have come across this complexity … once the groups are extracted, how do I add them to the separate datatable?

[Steven_McKeering]

Hello

Check out this video:

UiPath: Data Tables - How to build them, add data row and output data table

[joseantonio (RPASOFT)]

thanks for the video, but I can’t see how to convert those groups into variables … to add to the data table that I have already created for other documents

[joseantonio (RPASOFT)]

@joseantonio

(?<=EUR)\n\n(. ?(?=\s))\s(. ?(?=\s))\s(. ?(?=\s))\s(. ?(?=\s))\s(.*?(?=\s))

variable = (?<=EUR)\n\n(. ?(?=\s))\s(. ?(?=\s))\s(. ?(?=\s))\s(. ?(?=\s))\s(.*?(?=\s)).(0).Groups(3).Tostring

the example would be like this?

[joseantonio (RPASOFT)]

Maybe I did not explain it well, I try to create a datable with the regex expressions I am attaching the example, so I would like to know how to put group 0, group 1 in the expression …

[Steven_McKeering]

Sorry - wrong video.

Try this one:

UiPath - How to add data to a new Excel column - Full Tutorial

You will need to obtain group 3 first.

Essentially you will use an assign activity with something like this:
Row.item(“Value”).tostring = Group3

[joseantonio (RPASOFT)]

Unfortunately that is not working, since I store the entire chain with all the groups … and when assig is a loop it doesn’t work, the chain is the following

(?<=EUR)\n\n(. ?(?=\s))\s(. ?(?=\s))\s(. ?(?=\s))\s(. ?(?=\s))\s(.*?(?=\s))

There is no expression so that in the same Regex chain, I get the group that I want?

[Steven_McKeering]

Hello

Are you able to obtain Group 3 by itself?

You will have to conduct an interim step to get the data ready for processing.

[joseantonio (RPASOFT)]

Maybe you are using the wrong expression, in the link below, the expression I use appears,

1st I use matches and I introduce the expression in pattern, and I put an output variable, then I use a message box with the following MyVariable (0) .Groups (3) .toString ()

Perhaps it is the expression? Despite the fact that on the website that I attach the groups perform well for me?

regex101: build, test, and debug regex

[joseantonio (RPASOFT)]

help!

[Steven_McKeering]

@joseantonio

MyVariable (0) .Groups (3) .toString ()

Hello

Modify your syntax to remove the last “()”

[joseantonio (RPASOFT)]

@joseantonio

MyVariable (0) .Groups (3) .toString

I have changed the expression, but if I want to show the result in the message box, it returns the same expression, as if it were text … I have tried to include it in the datatable and it also gives an error, I will be doing something wrong … but I don’t know what

[Steven_McKeering]

Got a screenshot?

[joseantonio (RPASOFT)]

Thanks for the help, if with the capture you are able to see my error … since I cannot locate it

[Steven_McKeering]

Hello

I can’t see anywhere you are using Regex.

I see the Regex patterns but they need to be applied using a Matches activity.

I strongly recommend reading section 3 of my Regex Megapost.

So insert a Matches activity.
Here is your Pattern:
([\d.]+)\s([\d.]+)\s([\d.]+)\s([\d.]+)\s([\d.]+)
Here is a preview

The input will be your raw text.
Then you will need to assign each group from your result accordingly (I hope I have not misread any of your previous posts).

Hopefully this helps you

[joseantonio (RPASOFT)]

Maybe it is an organization problem, matches I use it later since I enter the expressions in a table and then the regex commands