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

Hello, I would appreciate some orientation to solve the following situation about converting PDFs to Excel:

  • 24 July 2019
  • 1 reply
  • 1 view
I

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

1 reply

redgeographics
Rank
Userlevel 5
Badge +25

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

28,670
Posts
109,366
Replies
36,531
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.