Power Query ; imported text data with no spaces

[nascaline]

Hi all,

I am new to power query, I'm currently having a problem importing data from PDF files.( i.e. the imported text has skipped all the spacing and output one string)

What I get from import:
| Description
| PLASTERINGANDPAVING;Applyingwhitepaint; NipponPaintZeroTecPaint;
| green; NN1307-4 Gysum;asspecifiedindrawingnr.

My desired result:
| Description
| PLASTERING AND PAVING ; Applying white paint; Nippon Paint Zero Tec Paint;
| green; NN1307-4 Gysum ; as specified in drawing nr.

Is there any way that I can try to get the text data above?
Many Thanks

PDF file sample can be downloaded in the link below:

Pages from rate data texting 6.pdf

drive.google.com

 

[Alex Blakenburg]

I had the same issue when I tried to import your file. I don't think you are going to like the only solution I could find.
The only way around it that I could find is to import the pdf into MS Word and save it as HTM, then import using Power Query import it as a Text file.
I got that method from here:- Import Tabular Data from PDF using Power Query - Excelerator BI - Sub heading "Import into Power Query".
They got the best result saving it as MHT but on your pdf I got a better result saving it as HTM.

If you can't get a better option and decide to use this follow the instructions on the Link I provided or if that is not clear let me know and I will provide more details.

 

[nascaline]

I had the same issue when I tried to import your file. I don't think you are going to like the only solution I could find.
The only way around it that I could find is to import the pdf into MS Word and save it as HTM, then import using Power Query import it as a Text file.
I got that method from here:- Import Tabular Data from PDF using Power Query - Excelerator BI - Sub heading "Import into Power Query".
They got the best result saving it as MHT but on your pdf I got a better result saving it as HTM.

If you can't get a better option and decide to use this follow the instructions on the Link I provided or if that is not clear let me know and I will provide more details.

Alex, Thanks for the help! Just tried it myself and the result seems fine for me.

 

[Alex Blakenburg]

Thanks for letting me know. Glad it worked for you.