3
What software can be used for editing CSV files? Notepad is gonna work smoothly? I have been using MS Excel but now I have this issue. When I put date like this: 090913 whcih represents 9th of Sept. 2013... I don't see the first zero in front of the date... Excel hides it? and the zero is still there? So I don't have to not worrying? I will use CSV file later when I will create Java application that will read from the CSV file....
first I would recommend you not use MMDDYY format, and use a 4digit year just to avoid ambiguity. that said, a text editor is the safest bet, but awkward. Excel is the better option, but since it does try to treat the data as numeric, you will have to tell it that the column is text, or a date for it to display correctly. – Frank Thomas – 2013-10-10T12:37:33.903