Re: CustomHow can I create pipe "|" delimited .csv ?

Hi Carl -

Once you open the file in Word & save your changes it retains the .csv
extension but it's no longer in a .csv format - it's saved as a MS Word Text
Document. Excel opens it directly - bypassing the import options. You need
to use the Data> Get External Data> Import Text File command in order to
activate the Import Wizard & make the spec you're referring to. Once you do
that, however, the pipe delimiter has been discarded.

Regards |:>)
Bob Jones
[MVP] Office:Mac



On 2/7/09 2:34 PM, in article
carl-DF157C.14340707022009@xxxxxxxxxxxxxxxxxxxxx, "Carl Witthoft"
<carl@xxxxxxxxxxxx> wrote:

I'm not sure I quite understand BobJ's final comment. If you open a
text file from the File/Open menu, you should get a dialog asking
whether the file has delimiters, and then you can specifically tell
Excel to use "|" as the delimiter.
Agreed that this should not be called a 'csv' file because that is
supposed to be purely (hah) for comma-delimited stuff. I forget what
Excel does in European languages which use "," for the decimal point.


In article <C5B31924.48DCC%onlygeneraltaz1@xxxxxxxxxxxx>,
CyberTaz <onlygeneraltaz1@xxxxxxxxxxxx> wrote:

The only suggestion I can offer is to open the CSV in a text editor that
provides a Find & Replace feature in order to swap the | for the , - I
haven't tested it thoroughly but theoretically that should work. I did so
with Word & the only problem is that - although Excel will reopen the file
it doesn't respect the pipe as a delimiter, so each record/row of data is
inserted into a single cell.

Unfortunately an extra step, but that's the best I can suggest.

HTH |:>)
Bob Jones
[MVP] Office:Mac



On 2/6/09 12:11 PM, in article 59b6bb9f.-1@xxxxxxxxxxxxxxxxxxxxxxx,
"lokihsu@xxxxxxxxxxxxxxxx" <lokihsu@xxxxxxxxxxxxxxxx> wrote:

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello,

For a specific project, I need to send speadsheets with pipe delimited .csv
formatted files to my client who is windows based.

For them to customize their .csv from comma delimited to pipe delimited,
they
go into their Regional settings on their Window's Control Panel. I can't
find
this option in Mac's System Preferences not Excel for Mac 2008's Save As
settings...

Apologies for the long explanation but hopefully the more information the
better for you guys to help.

.

Loading