PDF to CSV and Data Restructure

[RA6]

Hello folks,

I am extracting data from pdf to csv.

After extraction, the data is some kind of scattered and i need to assemble them cleanly.

Scattered data from pdf to csv

As you can see, the delimiter is | and the schema is different for each row.

What i am trying to do is to convert each rows into column:

Expected result:

Is there a way to do that?

Please advice.

Many thanks,

asadasing

[Knowme]

Can you please share how you converted PDF to csv using which component?

[RA6]

it is a custom component which is available in talend exchange.