Date: prev next · Thread: first prev next last
2018 Archives by date, by thread · List index

At 02:09 29/03/2018 -0500, Fudmer Rieley wrote:
i copy from a pdf text to calc and writer, but neither separated the numbers into column 1 and the column 2 information to another column

PDFs are not meant to be used in this way, so I'm not sure one can ever expect anything.

when I pasted the copy to writer this is what I got. it did not separate the stuff on either side of the : into two separate adjacent columns. ( I tried it both ways pasting into a table in writer or just pasting to a blank writer tab. )

C 32:
Specification for Sewer and Manhole Brick
(Made from Clay or Shale)

My real objective is to copy from the pdf source and end up with two columns in calc as followsz ( In the same form as I want, (shown below) is how the data appears in the original pdf text source..
C 32: Specification for Sewer and Manhole Brick (Made from Clay or Shale)

If you can get your pasted material into either a text or spreadsheet document in this form, you can easily get it into a single column of a spreadsheet. It is then a simple matter to separate the two parts at the colon. A simple way is to use Data | Text to Columns... . Tick the Other option and type a colon into the box. OK. The colon will be absorbed but you will be left with a leading space in your second column text. There are various ways to remove this: the simplest is probably to replace ": " (colon-space) with ":" (colon) - no quotes - before using the above technique.

I trust this helps.

Brian Barker

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.