I want to save a file with a particular delimmiter,
however it appears that Excel only has 2 delimiter type
files to save to.

I'd like to not have to manually change the delimiter each
time I save the file.

Is there a way to create a custom file type that I could
select that would have my chosen delimiter?

IE: Instead of .CSV with a comma as a field separator,
I'd like to have a ".DAT" or something with a pipe, | , as
the separator.

Thanks!

You should be able to write any information you want to a file, therefore
you could use any delimiter you want. It just takes a little more coding
(you would need to cycle through each cell of data, and concatenate the
delimiter between each value before writing the line of data) . You can
also save the file to any extension you would like.
Paul D

"Robert Minneman" <(E-Mail Removed)> wrote in message
news:058401c38dd7$51d87090$(E-Mail Removed)...
>
> I want to save a file with a particular delimmiter,
> however it appears that Excel only has 2 delimiter type
> files to save to.
>
> I'd like to not have to manually change the delimiter each
> time I save the file.
>
> Is there a way to create a custom file type that I could
> select that would have my chosen delimiter?
>
> IE: Instead of .CSV with a comma as a field separator,
> I'd like to have a ".DAT" or something with a pipe, | , as
> the separator.
>
> Thanks!

Yes, that's one possibility, however I was hoping for
something much more readily used when opening and
manipulating a lot of these files.

Plus, with a custom file type defined, I wouldn't have to
specify the delimmiter every time I opened the file and go
through the file import process, every time.

>-----Original Message-----
>You should be able to write any information you want to a
file, therefore
>you could use any delimiter you want. It just takes a
little more coding
>(you would need to cycle through each cell of data, and
concatenate the
>delimiter between each value before writing the line of
data) . You can
>also save the file to any extension you would like.
>Paul D
>
>"Robert Minneman" <(E-Mail Removed)>
wrote in message
>news:058401c38dd7$51d87090$(E-Mail Removed)...
>>
>> I want to save a file with a particular delimmiter,
>> however it appears that Excel only has 2 delimiter type
>> files to save to.
>>
>> I'd like to not have to manually change the delimiter
each
>> time I save the file.
>>
>> Is there a way to create a custom file type that I could
>> select that would have my chosen delimiter?
>>
>> IE: Instead of .CSV with a comma as a field separator,
>> I'd like to have a ".DAT" or something with a pipe, | ,
as
>> the separator.
>>
>> Thanks!
>
>
>.
>