Read PDF text and get the second occurrence

[Angie_Oviedo]

I hope you can help me.

In a PDF sheet I have two totals both are called “Total”.
How can I read both totals?

I am using the Read PDF Text activity.

To read the first match use: ReadPDF.Substring(ReadPDF.IndexOf(“Total”)+“Total”.Length).Split(Environment.NewLine.ToCharArray)(0)

But I can’t find the following match.
I have tried to use lastIndexOf but it reads “Total end” another data from the PDF.

[Steven_McKeering]

Hi @Angie_Oviedo

Take a look here:

Select 1st or 2nd match while using regex based extractor and problem in regex expression for address

Hi @emshihab You can use Regex to extract the results. To use Regex, you need 3 things: Sample/s Expected Output Pattern/Information on what is consistent in the text. As for Q1 - we need a strong pattern as Addresses can change in size and number of rows. I have a made a quick regex pattern for Q1. Please note this pattern is not robust and will just ignore the first line and start to match from the second line. Q.2 I have made a regex pattern for Q2. This will match the email addresses…

[Lak_Ui (Lakshmi)]

is there character common after totals you wanted to extract?

[Vaibhav_Rajpoot_17 (Vaibhav Rajpoot)]

@Angie_Oviedo

Can you share the pdf.

[sb001]

I Think You are Finding Something Like This

Use Matches Activity for Regex To Get Total Value,
And pass Read PDF Text activity output variable as an input of Matches activity.

To get second occurence of Total Value use This Expression
MatchList(1)

Hope it Helps.

Let me Know if you have any queries.

Regards,
Saloni

[sb001]

Hello @Angie_Oviedo

Mark it as Solution if it is working Fine.
So we can close the Topic.

Regards,
Saloni

[Angie_Oviedo]

Thanks for your help.
I have hardly used RegEx but it is a very good option.