topic CSV File Problem in Application Development and Automation Discussions

CSV File Problem

Former Member — Tue, 03 Feb 2009 12:38:07 GMT

Hi,

I am having a typical problem in CSV upload.

I create a file in excel and save it as .CSV

The data in one of the cell is "2 (double quote followed by a digit) Cell is formatted to Text.

After saving , when I see the CSV file in notepad, the data is seen as """2" (3 double quotes)

This when uploaded in the program throws the error obviously.

I know its the data problem but my question is:

1. Can this be handled in the program? If yes please guide.

2. Why is the excel behaving this way?

Thanks in advance

Re: CSV File Problem

former_member404244 — Tue, 03 Feb 2009 12:42:42 GMT

Hi,

I feel before u save to .CSV u have to make sure that the excel should have proper data ..so first check if the excel has any quotes , remove them and then save as .CSV.it's better rather than handling in program..

Regards,

Nagaraj

Re: CSV File Problem

Former Member — Tue, 03 Feb 2009 12:46:30 GMT

Excel has the Quotes.

The data in the excel is "2 and it is required.

After CSV creation, the data becomes """2"

Actual Data in Excel : "2

Data in CSV : """2"

I hope you got my question.

Thanks