vijay.gupta
Topic Starter
I recently bought android phone so I was transferring all my dat from my old phone to the new phone. On my old phone, I was using an application to track down my expenses that allows to export the csv file of the data that I have saved.
Now, on the android phone, I find a separate application for the same purpose. It also allows exporting and importing of csv files.
I am trying to import the csv file generated from my old phone to the new android phone.
I am not able to do this as the format of the csv files for both the applications are different.
I am posting both the files for old and new. Can anyone please let me know the procedure to change the format of the old csv file so that the format is supported by the new application.
Pleaase note that both the files look identical (also the formatting selected for the cells is same) when opened in MS Excel whereas the contents look different when opened in Notepad. I am pasting the example row from each file when opened in Notepad below:
Example row from application in old phone
3/13/2010 11:58,Atm,Citibank,600
Example row from application in new phone
"03-03-2010 09:49","Bus","test",-43
Now, I can change the format manually by opening the old file in Notepad but since there are hundreds of rows in the file, it is very tedious to do this manually.
Is there any restriction in this forum to upload excel files?