Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Data
  • Hello, I would appreciate some orientation to solve the following situation about converting PDFs to Excel:

I have a PDF file like this:

 

No.productleaderPartnerStatus1xxxcompany O5Parner1 (5%), Parner5 (80%)

 

Parner67 (15%)ok2yyycompany 08Parner A (50%)

 

Parner B (25%), Parner C (25%)ok3zzzcompany07Parner I (50%)

 

Parner II (50%)ok4bbbcompany10Parner k (100%)ok

 

And I need to have an excell file like :

 

No.ProductLeaderPartner%Status1xxxCompany 05Parner15%ok1xxxCompany 05Parner580%ok1xxxCompany 05Parner6715%ok2yyyCompany 08Parner A50%ok2yyyCompany 08parner B25%ok2yyyCompany 08Parner C25%ok3zzzCompany 07Parner I50%ok3zzzCompany 07Parner II50%ok4bbbcompany10Parner k100%ok

Any chance you can share that PDF (or a sample just like it) here? It kinda depends on how it is set up so if you share a sample it has to be produced exactly the same way.

For example, some PDF generators break up words in individual letters, which would make it a lot harder to extract them.

Reply


Community Stats

30,108
Posts
114,295
Replies
37,745
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.