Yes, you can set a pipe rather than a comma as a delimiter. It does not depend completely on Excel. It depends on Windows. The quickest way is to save the file as a CSV file.
To change the default on your PC to a pipe rather than a comma bring up your default options window by clicking Start -> Settings -> Control Panel -> Regional Settings.
Click the "Number" tab and in the "List Separator" field, replace the current default separator with the one you want to use (let's say a pipe symbol | ).
Click "OK" to save the change and close the window. You can now save Excel files as pipe delimited files by simply doing the following in Excel:
Open or Create a new file in Excel.
Click File => Save As on the menu bar.
In the "File Type" drop down, select "CSV (comma separated values) *.csv".
You can find the original post for the above here.
http://webxadmin.free.fr/article/excel-export-to-text-file-with-chosen-delimi-127.php
4 comments:
Briliant way!!! I've started to think about writing VB converter to convert ";" to "|" in text files:)
Your way is excellent!
Greetings from Poland
Pawel Koralewicz
Works a treat. Nice one.
This definite works for Excel - but if you use this it can mess up your formulas in Access. (changes commas to |)
I have the big "collection" of working excel documents. And one day all files were lost on unknown reason. I asked an advice to my friend. He suggested an one soft blog. I was lucky and saw there a tool, which resolved my trouble and as I understood it can help in your situation too - repair Excel file.
Post a Comment