Need to extract only column values using regex

[Debartha_Mitra_DE]

Hi,
I have a following sample text in table format (extracted from pdf) from where i need to extract the third columns’ (Beschreibung) values only. The following extracted value is text, not a table.

Nr.     Bauteilgruppe                   Beschreibung
1       Ausrüstung                      Fahrzeugschlüssel m. Fernb. (2x Batterien leer) - --- - erneuern
2       Tür vorn links                  Tür - Dellen - sanft instandsetzen
3       Instrumententafel               Ablagefachdeckel (Sitzt schräg) - abweichend Auslieferungszustand -
                                        einstellen/justieren

I think I only have option to use regex ?
Any suggestion on this ?

[svillalobos (Sebastian Villalobos)]

Hi,

First to use a filter datable activity and use it to filter and leave only the third column.

Then use for each row activity and within it Use the regex activity on each row.

Hope this helps

[Debartha_Mitra_DE]

sorry, actually the above one is a text only, extracted from pdf in table format. Its not a table.
I need to get the values under “Beschreibung”

[pikorpa (Piotr Kołakowski)]

Hey,
Maybe you will try replaced text where you have more then one space to character ‘;’ and create csv file ?

[ppr (Peter Preuss)]

in general we would try to split into the different columns, targeting in a way that we can parse it as CSV into a datatable

But we cannot do on split by space. With following approach we can achieve the most of cases

Except of last line

When we can rely on following assumption: there never will be a | in use. We can do:

• Substitution of multiple spaces to | - Regex.Replace
• Split the text on Line Breaks - Split, Regex.Split
• look for the line only having 1 | - insert missing | on this line on begin - LINQ

Feed the enhanced and corrected text lines to a Generate DataTable activity and handle it as CSV Data

it will return a data table, which we can process, e.g Filter datatable and keep only column Beschreibung

[svillalobos (Sebastian Villalobos)]

Understood.

In that case I can think of 2 options.

1. Try to convert the text into a Data Table. By using the Output Data Table activity.
   Here is the documentation for this activity, it has an example also.

Output Data Table

2. An alternative to this will be to use Document understanding. Which is a bit more work, but very powerful and a very good skill to master. UiPath Academy offers a great course on this.

UiPath Document Understanding Overview

[Debartha_Mitra_DE]

Hi, thanks for your reply.
can you please provide it with example (or the code) ?
It will be very helpful.

thanks.

[ppr (Peter Preuss)]

Find some starter samples:

Getting the lines that needs to be corrected ( we can use for a for each)

Generate data tatable:

Just start the implementation and we are sure you will get it done the most by yourself