Custom File Types
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" wrote in message ... 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! |
Custom File Types
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" wrote in message ... 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! . |
All times are GMT +1. The time now is 12:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com