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+h...@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
