Custom File Types

[Robert Minneman]

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!

 

[Paul D]

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]

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.