0

In CSV file all other delimiters are comma except for 1 colon. While saving this CSV, excel replaces this colon to comma.

How can I overcome this? or Later how can I replace those particular comma with colon?

3
  • Are you trying to do this from Excel? Can you post an example of your CSV file?
    – iWerner
    Jul 9, 2012 at 9:42
  • Here is example file: sendspace.com/file/p6a4fj
    – JnkPanchal
    Jul 9, 2012 at 9:55
  • I have tried saving the sample you provided to each of the possible csv formats available in excel and have not seen the : be replaced. do you have a sample of a file where this has occurred also?
    – datatoo
    Jul 10, 2012 at 16:42

0

You must log in to answer this question.