Looking for assistance in extracting report-Talend data profiler

[MHazarika1600262358]

Hi Team,

Writing this email with a query in extracting reports from Talend data profiling jobs. We have already extracted reports in PDF and XLS format, wherein we observed the images of analysis results were pasted to both the reports.

But our requirement is to extract reports of the analysis results in rows & columns to an excel file. So would like to request your assistance in below mentioned

1. Is there any way to extract text which is showing up in PDF reports to an Excel sheet without the images.
2. Is there any way to get the same metrics from backend DB if at all talend stores these information.

Thanking you,

[cadap]

Hi,

to convert a pdf to plain text you could use the "pdftotext" command line utility. In Linux this is part of the poppler-utils package.

You can then use the extracted text and covert it to every format you want.

Hope this helps.