Need to extract information from PDF using Regular expression

[Debartha_Mitra_DE]

Hi,
I need to extract information for two tags from a list of pdfs using regular expression.
The structure of every pdf would be same.

The first word tag is Wertmindernde Faktoren (in bold) and it will always have information like below (in table manner)

As you can see the information is in table format and I need to use regex to extract in table format only for this particular tag.

The second tag is Gebrauchsspuren (in bold)
This will have information sometimes in table format or sometimes in a sentence.
Mentioned below

Table format

Information in sentence format (when no data is available)

So any help or suggestion on what will be the regex for these two tags ?

Thanks in advance.

[ppr (Peter Preuss)]

Two strategies could be found at least (we assume text can be split into the lines

Filtering

• start line grabbing when the keyword is detected
• stop filtering the the typically tabular format pattern has been added
• feed it to a generate table activity

*Slicing and index

• match all lines on the tabular format pattern
• identify the table starters while checking the match position index
• check for keyword before first table data line
• feed it to a generate table activity

[CheatSheet] - System.Text.RegularExpressions | RegEx

This CheatSheet introduces the basic use of regex functions. With further examples also special cases are presented. Introduction From the namespace System.Text.RegularExpressions following methods are offered: Regex.Match Regex.Matches Regex.isMatch Regex.Replace Regex.Split A simple usage for example would look like this: [grafik] Recommendation: add System.Text.RegularExpressions to the imports: [grafik] it allows to use the shortened statement, as the namespace part can be ommited…

[Debartha_Mitra_DE]

Thanks for the reply, can you please elaborate more or provide me a small poc on these ?

[ppr (Peter Preuss)]

please provide some sample text

[Debartha_Mitra_DE]

Hi Please find the sample below

"hinten zu 65% abgedunkelt
Verkehrszeichenerkennung
Vordersitze beheizbar
Vordersitze elektrisch einstellbar, Fahrersitz mit Memory, Komforteinstieg, längs verschiebbarer
Oberschenkelauflage
Wegfahrsperre elektronisch

20.07.2021 Gutachtennummer: XXXXXX Seite 6 / 17TÜV SÜD Auto Plus GmbH Fahrzeugbewertung
Wiesenring 2
04159 Leipzig
XXXXXXXXX
GUTACHTENNUMMER: XXXXXX
Bei Rückfragen bitte Gutachtennummer und Datum angeben Datum: 20.07.2021

Ausstattung
Zentralverriegelung ohne Safe-Sicherung,mit Funkfernbedienung, 2 Funkschlüssel, Komfortstartfunktion
“Press & Drive”

Wertmindernde Faktoren
Nr. Bauteilgruppe Beschreibung
1 Heckklappe/-tür Heckklappe - Dellen - sanft instandsetzen

Gebrauchsspuren
Nr. Bauteilgruppe Beschreibung
1 Stossfänger vorn Spoiler (Unterhalb) - Kratzer - kein Abzug
2 Stossfänger hinten Stossfänger hinten - Kratzer - kein Abzug
3 Tür hinten rechts Tür - Dellen - kein Abzug
4 Tür vorn rechts Tür - Dellen - kein Abzug

Vorschaden
Nr. Vorschaden Schadenshöhe
1 fachgerecht repariert , Reparaturrechnung nicht vorhanden 311,10 €
2 fachgerecht repariert , Reparaturrechnung nicht vorhanden 493,31 €
3 Seite links, fachgerecht repariert , Reparaturrechnung nicht vorhanden

Summe (netto): 804,41 €"

I didnt put whole data as it has some sensitive information as well.

So as you can see I need to extract table for “Wertmindernde Faktoren” and table for “Gebrauchsspuren”. These two words usually come in bold letter. You can refer my post to see the structure of these two tables.

FYI, as I mentioned I have a list pdfs from which I need to extract these tables, the structure of these table will be same in all of the pdfs.

[yrobert (Yves)]

hi there,
for good regex extraction of a table, it can be helpfull to keep formatting:

do you see a difference?

[Debartha_Mitra_DE]

yes, actually I already did it and wrote the extracted information from pdf to a txt file.
Please find the text in the attachment. You can find the correct format there.

TUV_Data - Copy.txt (2.3 KB)

I have to omit some information as it has some sensitive data.

Thanks in advance.

[Debartha_Mitra_DE]

@ppr please find the text file which has the information (it has preserved format)

TUV_Data - Copy.txt (2.3 KB)

[Debartha_Mitra_DE]

@ppr @yrobert
I created this regular expression which is working on regex101.com but not working in UiPath

(?:Wertmindernde Faktoren|Gebrauchsspuren.)\n(.(?:\n.+)*)

any suggestion on how should I modify this ?

[ppr (Peter Preuss)]

@Debartha_Mitra_DE

(?:Wertmindernde Faktoren|Gebrauchsspuren. )\n(. (?:\n.+)*)

(?:Wertmindernde Faktoren|Gebrauchsspuren. )\r?\n(. (?:\n.+)*)

include optional \r? and check again - handling windoes linebreak specifics

[Debartha_Mitra_DE]

thanks for your response, I gave the wrong regex previously by mistake, it is actually

(?:Wertmindernde Faktoren|Gebrauchsspuren.)\n(.(?:\n.+)*)

I put the optional windows linebreaker as well but didnt work,

so my code is currently like this

in the Assign activity I put the below code

matchString=Regex.Match(extractedText, “(?:Wertmindernde Faktoren|Gebrauchsspuren.)\r?\n(.(?:\n.+)*)”).Value

and then I printed it, but didnt work in uipath.

Let me know if I missed anything.

Thanks

[ppr (Peter Preuss)]

@Debartha_Mitra_DE
can you check?

(?:Wertmindernde Faktoren|Gebrauchsspuren)(?:.?\r?\n)(.|\n)?(?=\r?\n\r?\n)

[Debartha_Mitra_DE]

thanks for your modification, it worked