errors in tabbed txt (csv)

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 :frowning:

Is there a way to reliably export tabbed txt?

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

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.