MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Saving to a user-specified delimited file

Posted by Pete on August 29, 2000 5:11 PM

Has anyone ran across how to save an Excel file to something other than a text, comma-delimited, or tab-delimited file?

For example, would it be possible to save a file in a pipe-delimited (|) or > format?

Posted by Pete on August 30, 0100 7:52 AM

Unfortunately this won't work for importing the file into a database when your cells contain commas as well. What I was hoping to accomplish was to somehow change the column delimiters upon saving the file. I was hoping to circumvent the following with a funky vba command.

The commas within the cells could be changed to something else and then the file saved as .csv, then do the above procedures in Word to change the delimiters to intended formats.

I'm actually trying to avoid using any UNIX commands to do any of the conversions before loading into Oracle. (Even though the UNIX folks will say this is a piece of cake...)

Posted by Celia on August 30, 0100 8:56 AM

Sorry, don't know. Maybe someone else can help.

Posted by Celia on August 29, 0100 6:51 PM

For example, would it be possible to save a file in a pipe-delimited (|) or > format?

Here is a copy of some messages on this subject that were recently posted at:-

By Vince Tam on Monday, August 28, 2000 - 04:35 pm:
I was wondering whether you can save an excel spreadsheet as a text file with a delimiter other than tab or comma? If it can be done, could you please explain how to do it.
By kevin on Monday, August 28, 2000 - 07:12 pm:
When you save an Excel file, you're saving it either as a spreadsheet or a delimited file. Excel's nature is to have you save it as, for example, a CSV file, so that Excel can then reopen it.

I'm not sure what purpose you have for wanting something else as a delimeter. But, you could, for example, save the CSV file, open that in WORD, replace the commas with, say, !, and save that file as a TEXT file (suffix: txt).

Excel will "open" it but ask you about the delimiters. Specify "other" and indicate the delimiter is ! .

Will this do what you want to do?