Ask Your Question
0

How to achieve test tab delimited files from xlsx files please [closed]

asked 2013-10-31 13:35:24 +0200

HelenAA gravatar image

updated 2015-08-29 21:40:02 +0200

Alex Kemp gravatar image

For txt you can only save to .csv. This gives you various choices but remains csv whereas I need a true txt file. You can save BACK from csv to .txt, but then a load of """ marks and even ,,,,, rows appear in the list of texts, and in one case the program removed all the text commas from my entries!

Any pointers would be welcome.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-12 15:52:53.677006

1 Answer

Sort by » oldest newest most voted
0

answered 2013-10-31 16:14:59 +0200

kcbehler gravatar image

Hi Helen,

from your question it is not completely clear what you have and what you really want. So I describe two cases.

First case:

You are having a .ods or .xlsx spread sheet document wanting to export it into an ASCII text file that looks like a table. Choose "save as", select file type .csv and give a new file name. Pressing "save" a pop-up window "Export of text files" appears. If you tick the box "fixed column width" on the lower left, the export function generates a .csv file which does not contain delimiters but pads your table with blanks to the respective appropriate fixed width column size. Rename the resulting file to .txt you are done. (You may import this text file into Calc at any time using the fixed width feature for importing .csv text files into a sheet.) Be careful, only the current sheet will be exported to your text file.

Second case:

You already have a csv file containing delimiters and text "" marks. Open this file with LO and use the appropriate import settings to get a nicely shaped sheet from your .csv table. If you now would try to save it immediately as text again, the "Export of text files" pop-up does not appear, because the file is already in text format. So save it as .ods file (convert it to .ods format) first and then save again as .csv. Now the description for the first case should apply.

Hope I met your problem.

Karl

edit flag offensive delete link more

Comments

HI Karl Thanks very much for the suggestions and I will experiment with them

However my actual situation is that I must deliver a .txt file, and it must be text tab delimited. The "working" file format is an xlxs with three colums (size doesn't matter) containing text, but the "final" is a .txt file with tab delimiters, I don't have a choice in the matter. I cannot deliver a .csv, their system won't read it. It will ultimately be used in a database over which I have no control or knowledge!

tx

Update: regrettably neither suggestion produces a solution ... the first one dumped all the numbers and left nice clean columns with most of the text ...(more)

HelenAA gravatar imageHelenAA ( 2013-10-31 16:37:40 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2013-10-31 13:35:24 +0200

Seen: 1,833 times

Last updated: Oct 31 '13