How to read comma value form csv file

[Vinay Nagariya]

Hi, 

 

I am having big excel data sheet which contains formula and its taking too much time to load the test case due to formula, so I have converted the excel sheet into the CSV file using java code. 

Problem statement - My excel having Amount column which is having amount as $50,0000 and when its getting converted to CSV the value is "50,0000". 

As per the java code. 

 

IS there any way to remove double quote while inserting the data in DB using JDBC step ?

or can we remove the quote while converting to CSV .

 

Regards, 

Vinay Nagariya 

[Vish G]

Hi,

   String n="\"50,0000\"";
   String m = n.replaceAll("^\"|\"$", "");

The above lines of code will work in JAVA.

 

Vish