save text "|" delimited

[glenne]

I have a requirement to provide "||" delimited text files that are base
on existing excel worksheets.

Anyone know if it's possible to "save as" using a different characte
than "," space or tab?

Glen

 

[Guest]

DIF (Data Interchange Format) that might help.
not a expert in area thuogh...

 

[Dave Peterson]

Change your windows regional settings to a pipe.

Windows start button
settings|control panel|regional settings applet|Number Tab

List Separator (near the bottom).

This is a windows setting, so it may affect other stuff. I'd change it back
when I was done.

And if you want to write your own macro (so you have complete control):

Some samples:

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

Earl Kiosterud's:
http://www.tushar-mehta.com/
Look for Text Write in the left hand frame.

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

Earl's has a bunch of settings that you can vary. It might be sufficient.