Issue with exporting a CSV file to Oracle

HCL Domino Domino Forum
1

hello,

I am exporting the csv file to Oracle and having problem with the double quotes in csv file.

Ex:

Emp id, empname, Description, date

“123”, “John Doe”, “this is my test, “this is important””, “1/4/2008”

its putting the values in wrong columns of oracle table

I am not supposed to make any changes to the notes agent to change the outcome.

How can I remove the extra quotes from the description in CSV file? Please let me know.

Thanks

sri

2

Subject: Issue with exporting a CSV file to Oracle

Have you checked your data to see if there really is a quote on the end of that field?If not, thne you’ll ether ahve to editthe data by hand, or wrte a new agent to re-read and re-write the data with all quotes removed, or change the agent