Add compound objects with tab-delimited text
Whenever I copy tabularly-organized data from a PDF or website, it usually shows up as space-delimited values in Excel. When pasting space-delimited values into Excel, they all go into the same column. This isn't helpful when I want to make a table out of the data, sort the data, or basically perform any operation on the data. Here's an example of a line of data:.
In this article
This data is tabularly-organized in the PDF though, meaning no matter what the length of the Location field, the values in the next column are all aligned. For example, this is how it would look in the PDF:.
Is there a quick way to get way to get the space-delimited values so often seen into tab-delimited values for easy pasting into Excel?
HOW O CONVERT PDF INTO TEXT (FILE) OR WORD DOCUMENT
Is there perhaps some formatting that I'm missing when copying that's turning all tabs to space? Is there perhaps a program that can extract the tabs that seem to be lost when copying? This are so many ways to draw tabbed text in to a PDF while which makes it impossible to reliably convert text to columns. Some PDF will draw each character individually this way.
Others will draw "Hello W" and "orld" as two separate words. Characters can have character spacing and word spacing values applied as well as scaling, rotation etc. I have seen all sorts of ways of drawing text which is why you need a solid PDF to Text library to get the best results.
Proportianal fonts will also cause you lots of issues. Learn more. Asked 5 years, 8 months ago.
DID YOU KNOW?
Active 5 years, 3 months ago. Viewed times. Patrick Patrick 2, 2 2 gold badges 19 19 silver badges 30 30 bronze badges. There is no quick way to get the columns from your text without writing some fancy code.
Andrew Cash Andrew Cash 2, 1 1 gold badge 14 14 silver badges 10 10 bronze badges. Darn, thanks for the informative answer though.
Subscribe to RSS
I didn't know that's how text in a PDF was drawn. Sign up or log in Sign up using Google.
Sign up using Facebook. Sign up using Email and Password.
Post as a guest Name. Email Required, but never shown. How to create micro-interactions with react-spring: Part 1. This week, StackOverflowKnows syntactic sugar, overfit or nah, and the….
Featured on Meta. Thank you, Robert Cartaino. Change in roles for Jon Ericson leaving SE.
Has Stack Exchange rescinded moderator access to the featured tag on Meta? How do the moderator resignations affect me and the community? Related 6.
Convert TXT to PDF