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

Why doesn't the software accept standard CSV files?

Whit wrote:

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

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.

Whit wrote:

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

--

Dave Peterson

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

"Bob I" wrote:

Why doesn't the software accept standard CSV files?

Whit wrote:

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

Wow, makes you wonder doesn't it!

Whit wrote:

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

"Bob I" wrote:


Why doesn't the software accept standard CSV files?

Whit wrote:


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

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 windowsstartcontrol 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


--
Regards,

Peo Sjoblom



"Bob I" wrote in message
...
Wow, makes you wonder doesn't it!

Whit wrote:

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

"Bob I" wrote:


Why doesn't the software accept standard CSV files?

Whit wrote:


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