save options

[Max]

can anyone tell me how to save a worksheet as a csv file with
semi-colons instead of the default, comma delimited format. The
standard mac export csv file is not compatible with databases for the
internet or pc's and therefore even if i do a find and replace in a
text editor only the first line of the worksheet is downloaded. Please
help

Thanks

Max

 

[JE McGimpsey]

can anyone tell me how to save a worksheet as a csv file with
semi-colons instead of the default, comma delimited format. The
standard mac export csv file is not compatible with databases for the
internet or pc's and therefore even if i do a find and replace in a
text editor only the first line of the worksheet is downloaded. Please
help

I'm not sure what you mean by "not compatible with databases for the
internet or pc's" - I produce csv (*comma* separated value) files that
are exchanged with clients using MySQL and pc's at least monthly. Some
applications still choke on line endings (Macs use a CR, or ASCII 13,
Unix uses LF, or ASCII 10, and Windows uses both), but semicolons won't
fix that.

XL produces csv files using the thousands separator in your System
Preferences.

OTOH, you can choose any separator you want if you use VBA. See

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

 

[Paul Berkowitz]

I'm not sure what you mean by "not compatible with databases for the
internet or pc's" - I produce csv (*comma* separated value) files that
are exchanged with clients using MySQL and pc's at least monthly. Some
applications still choke on line endings (Macs use a CR, or ASCII 13,
Unix uses LF, or ASCII 10, and Windows uses both), but semicolons won't
fix that.

XL produces csv files using the thousands separator in your System
Preferences.

OTOH, you can choose any separator you want if you use VBA. See

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

And to avoid the Mac-line-ending issue you can Save As, and switch the
Format to CSV (Windows) [or CSV (MS-DOS)]. That's probably what he wants.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.