I never know how that may happen.
I really really hate it.
That's because my program counts on csv files being csv.
And I never know, until now, how can my csv file becomes tab delimited format
Did I click save as?
Did I save as usual?
It's a csv files. I always want it to be csv.
Sometimes I open the file and found out that the comma is gone. I got to do
Data -> text to column
To fix that up. And then save again. If I save again, it's csv allright. But how the hell it become tab delimited in the first place? I never ever instruct excel to save it in tab delimited. How can that happens at all? The extension is still .csv.
Additional info
- I rarely save the file. I usually get out of excel and some prompt may have show up. I may have save it without knowing.
- If I try to do file save as, excel will default to "txt" even though the file is clearly .csv files
- However, if I just save in a hurry, it won't save to .csv files. It will save to .csv.txt files. So to have my .csv files to contain tab delimited value do not seem to make sense at all.
The program that uses the CSV is my own custom made program. I now arrange that it can read both tab and comma. However, the program is very error sensitive when it comes to its input. That mistake have costed me hundreds of dollars already.