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


Hi :)
Don't worry.  Almost everyone uses an imperfect email client and the list can't always cope with 
all the foibles.  So, we have all fallen foul of some nasty trap that is outside of our control.  
No apology is  necessary but it's nice to see.  

Nicely handled!
Many thanks and regards from
Tom :) 


--- On Thu, 31/5/12, Paul D. Mirowsky <p_mirowsky@bentaxna.com> wrote:

From: Paul D. Mirowsky <p_mirowsky@bentaxna.com>
Subject: Re: [libreoffice-users] Problem when exporting exporting from CALC to a fixed length csv
To: users@global.libreoffice.org
Date: Thursday, 31 May, 2012, 1:10

Feel like idiot

e-mail strips end spaces.
Dohhh!!!

Generate the same data in calc, save it as a cvs with fixed format.  I'm pretty sure when you open 
it with either Notepad or Writer (don't forget to change it to a .txt document for writer) you'll 
get same results.

On 5/30/2012 8:01 PM, Paul D. Mirowsky wrote:
The following is the output of a Calc test document.
Clicked on upper left block to select entire sheet.
Right click on top of column and selected <Format cells>
Font tab - font to fixed length font, Letter Gothic.
Border tab - spacing to font set at zero (0)
Clicked on upper left block to select entire sheet.
Menu: <Format><Column><optimal width>Add 0"
The results copied here show that there is definitely 2 spaces being added after each column.  
Although you can't see it, go to the end of the last column and you can backspace twice.
It is not accurate to say that Calc uses the width of the column.

test_column-A1   test_column-B25  Test_column-C50  Test_column-D75
test_column-A2   test_column-B26  Test_column-C51  Test_column-D76
test_column-A3   test_column-B27  Test_column-C52  Test_column-D77
test_column-A4   test_column-B28  Test_column-C53  Test_column-D78
test_column-A5   test_column-B29  Test_column-C54  Test_column-D79
test_column-A6   test_column-B30  Test_column-C55  Test_column-D80
test_column-A7   test_column-B31  Test_column-C56  Test_column-D81
test_column-A8   test_column-B32  Test_column-C57  Test_column-D82
test_column-A9   test_column-B33  Test_column-C58  Test_column-D83
test_column-A10  test_column-B34  Test_column-C59  Test_column-D84
test_column-A11  test_column-B35  Test_column-C60  Test_column-D85
test_column-A12  test_column-B36  Test_column-C61  Test_column-D86
test_column-A13  test_column-B37  Test_column-C62  Test_column-D87
test_column-A14  test_column-B38  Test_column-C63  Test_column-D88
test_column-A15  test_column-B39  Test_column-C64  Test_column-D89
test_column-A16  test_column-B40  Test_column-C65  Test_column-D90
test_column-A17  test_column-B41  Test_column-C66  Test_column-D91
test_column-A18  test_column-B42  Test_column-C67  Test_column-D92
test_column-A19  test_column-B43  Test_column-C68  Test_column-D93
test_column-A20  test_column-B44  Test_column-C69  Test_column-D94
test_column-A21  test_column-B45  Test_column-C70  Test_column-D95
test_column-A22  test_column-B46  Test_column-C71  Test_column-D96
test_column-A23  test_column-B47  Test_column-C72  Test_column-D97
test_column-A24  test_column-B48  Test_column-C73  Test_column-D98
test_column-A25  test_column-B49  Test_column-C74  Test_column-D99


On 5/30/2012 2:21 PM, berritorre wrote:
I need to generate a fixed-length ascii/text file from a table that I have.
Fixed length ascii seems to be the format to import in a software my client
uses.

So I was fiddeling around and hat a lot of problems. Excel would export to
.prn just as I need it, but only for for 255 characters per line. I have a
few thousand columns in my spreadsheet with quite a few columns with more
than one character.

In LobreOffice I found the option to export to csv with fixed length and
actually this would be what I am looking for. However, Libreoffice seems to
add a space to separate columns, which just doesn't fit with fixed-length
ascii, as they shouldn't have separators/delimiters. I can't just replace
the spaces with "nothing", as there need to be spaces in the file to fill up
the columns when in a column there can be for example up to 5 characters,
but sometimes there are less.

So here would be a csv file with delimiter:


As a fixed length ascii file it should look like this:


But unfortunately, LibreOffice inserts some a space in front of each column.


I hope this will show up correctly now.

-- View this message in context: 
http://nabble.documentfoundation.org/Problem-when-exporting-exporting-from-CALC-to-a-fixed-length-csv-tp3986825.html
Sent from the Users mailing list archive at Nabble.com.



-- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


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.