Get values after specific text

[Tereza_Steflova (Tereza)]

Hi,

I would like to ask for an advice. I need to extract data from a text. I have to get Sub total, GST and Total as variables from a text that looks like this:

I tried splitting the text, RegEx activities…but I am still not getting anything useful. Can someone help?

Thank you very much

Tereza

[hasib08 (Motiwala Hasib)]

Is the format same for every file?
If so then can you share the text so we can apply the regex

[Tereza_Steflova (Tereza)]

yes, all files have this kind of format

[hasib08 (Motiwala Hasib)]

Can you share the text for applying regex

[KannanSuresh]

You can use the following regex patterns.

(?<=Sub Total )\d+[.]\d+ for Sub Total
(?<=GST \d\d% )\d+[.]\d+|(?<=GST \d% )\d+[.]\d+ for GST
(?<=Total )\d+[.]\d+ for total

A grouped regex will look like below

((?<=Sub Total )\d+[.]\d+)|((?<=GST \d\d% )\d+[.]\d+|(?<=GST \d% )\d+[.]\d+)|((?<=Total )\d+[.]\d+)

regex101: build, test, and debug regex

[Steven_McKeering]

Hello

If you want to learn Regex - check out my 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…

[Tereza_Steflova (Tereza)]

Thank you very much…can you just help me with the formula? I can assign the variable Sub Total to regex expression using Match or another?

[nerusan.indramohan]

Why don’t you try using anchor base activity?

[Tereza_Steflova (Tereza)]

@KannanSuresh

(?<=Sub Total )\d+[.]\d+

I tried to use anchor and get text activity but it works always only for the first pdf file and the element cannot be found in the next…

[nerusan.indramohan]

Maybe beacuse it’s attached to a specific pdf url.
Try to move ther action out of the seqence, if it makes sense
Else try to make the pdf url dynamic,… Does it help?

[Tereza_Steflova (Tereza)]

Not really, it is not connected to any URL…

[nerusan.indramohan]

Will you send me a screenshot, unless the problem is solved?

[Tereza_Steflova (Tereza)]

My task is to get the sub Total, GTS and Total data from several pdf files, however, they ar eat the end of the document:

I used start process to be able to open the pdf:

But using Get Text and Anchor base activity is still working just for first file, in other UI element cannot be found. I edited the selector by *.pdf…but is still not dynamic enough