AnsweredAssumed Answered

How to read comma value form csv file

Question asked by Vinay Nagariya on Jul 23, 2018
Latest reply on Jul 23, 2018 by LearnNow

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 

Outcomes