Ask Your Question
0

errors in tabbed txt (csv)

asked 2016-02-18 13:40:00 +0100

LizJ gravatar image

updated 2016-03-08 22:12:56 +0100

Alex Kemp gravatar image

if there is a column in my ods file that contains different lengths of data, (say a customer PO number where the format varies wildly by customer) when I save as csv and select {Tab} as the field delimiter, then the data can be misaligned, and in the wrong columns in some rows.

If I save as csv, select {Tab as the field delimiter and check the Fixed Column width option, the the data is aligned correctly, and in the correct columns, but some fields are truncated and data is lost.

I have had to revert to excel to produce correctly tabbed txt files :-(

Is there a way to reliably export tabbed txt?

Version: 5.0.3.2 (x64) Build ID: e5f16313668ac592c1bfb310f4390624e3dbfb75 Locale: en-GB (en_GB)

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-02-23 21:34:07 +0100

DylanV gravatar image

The fixed column width is what is truncating your text. It's doing what it says, limiting the column to a fixed width.

So, just don't check that, and all the cell contents are exported.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-02-18 13:40:00 +0100

Seen: 29 times

Last updated: Feb 18 '16