Hi :) Isn't there an option for "tab delimiter"? Would that help? I'm not sure it would tbh but it might be what 'they' are looking for. Regards from Tom :)
--- On Wed, 30/5/12, berritorre <berrito...@gmail.com> wrote: From: berritorre <berrito...@gmail.com> Subject: [libreoffice-users] Re: Problem when exporting exporting from CALC to a fixed length csv To: users@global.libreoffice.org Date: Wednesday, 30 May, 2012, 20:15 Thanks for your response. I have tried CSVed before. Actually, I don't really want to work with the csv files. Actually doesn't even need to be a csv file. Any ASCII text file probably does. It just has to have the correct format. So my client sends me a data map where he specifies the exact width for each column. E.g. Variable 1: Positions 1-4 Variable 2: Positions 5-6 Variable 3: Positions 7-10 My software generates csv files with ";" as delimiter which works perfect for importing in Calc or Excel. But then I have to follow my clients requests and the document has to have exactly the required format. So what I do is I add a row at the top with the max. number of characters for this specific variable, e.g. if it would be variable 1 from the example above, the first line would look like this: "1234". This is how I guarantee the length. I found a software that is generating .sdf files from csv files (called Convert). But actually I would like to do it directly from a spreadsheet software, to avoid another software. Libreoffice almost does it right. It just takes the visible width of the column as the width to export and not the max. characters in a column. When I adapt the column width manually to the minium which still allows to see all characters Libreoffice exports correctly!! So I would just need to find a way to avoid this little visible space on the left of the cell. Excel adapts the columns correctly and doesn't add space to the left, but minimizes the column to exactly the width necessary to show all characters, but then Excel doesn't allow to export fixed field csv files. -- View this message in context: http://nabble.documentfoundation.org/Problem-when-exporting-exporting-from-CALC-to-a-fixed-length-csv-tp3986825p3986844.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 -- 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