Hi all,
Can someone tell me how to generate a CSV file and handle the case when values contain comma in them.
If i use MyString.replaceAll(",","\,")->this is not allowed, i will have to use MyString.replaceAll(",","\\,"),but finally these two backslash cancel each other and what is left is comma.
I want to create CSV file while exporting data from database and while
importing i will use this file to pump the data,so i want to differentiate
between comma as seperater and comma as part of data.
Please help me on this...
Can someone tell me how to generate a CSV file and handle the case when values contain comma in them.
If i use MyString.replaceAll(",","\,")->this is not allowed, i will have to use MyString.replaceAll(",","\\,"),but finally these two backslash cancel each other and what is left is comma.
I want to create CSV file while exporting data from database and while
importing i will use this file to pump the data,so i want to differentiate
between comma as seperater and comma as part of data.
Please help me on this...