Semi Colon Deliminated File

[Guest]

The software that I use requires a specific format in order to upload data.
Is there a way to save a file with a semi colon as a deliminator. I can save
as a comma file and then import into word pad, then repalce with a semi
colon. There has to be a better way.

Thanks

 

[Bob I]

Why doesn't the software accept standard CSV files?

 

[Dave Peterson]

You can change your windows list separator to a semi colon.

Go to windows control panel, regional and language options|Regional options tab
then click customize and look for List separator on the Numbers tab.

I'd change it back when you're done--it's a windows setting and you may not like
it as your default.

Another option would be to use a macro.

You could use a macro and write code and have complete control over what you
write.

Here are three sites that you could steal some code from:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

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

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

Earl's program may work right out of the box.

 

[Guest]

??? I have asked the same question. The quote from a programmer was: "Our
largest client wants it this way." Go figure.

 

[Bob I]

Wow, makes you wonder doesn't it!

??? I have asked the same question. The quote from a programmer was: "Our
largest client wants it this way." Go figure.

:

 

[Peo Sjoblom]

I believe it's the default format for continental Europe, so maybe they do
business with Europe

One way (in windows xp) is to do windows>start>control panel> regional
settings, click customize and change list separator from comma to semicolon.
That way when you save as *.CSV it will replace the commas with semicolon.
Of course you need to remember to change it back when you are done. Don't
know if that's easier than to open it in a text program and replace them.
OTOH there are quite a lot of code out there for exporting excel files using
other delimiters. McGimpsey's website is down at the moment

http://www.mcgimpsey.com/excel/textfiles.html


http://www.cpearson.com/excel/ImpText.aspx