import CSV data with comments field

[Yago]

Hi team,

I am trying to import a CSV file using tools > text importer.... The problem is my file contains some comments fields. A comment field is a cell that contains any character writen by the user such as a forum post, for example.

The importer tool get stuck when arrives at first comment field which has a " char. Then, this char is interpreted as separator but is not it.

How can I bypass this? Some ideas?

Thanks for all team,
Yago

 

[Marco Kalter]

Maybe the CSV file is not valid CSV if user text with special characters is not converted to valid a CSV value.

For example:

This is "my" comment

should be stored in CSV as:

"This is ""my"" comment"

 

[Yago]

Hi Marco,

I check this file and contains double-double quotes in comments as you said. I think that is well-formed because in Qlikview or Excel I could import this CSV file without problems but not in Oracle with this application.

Then, I do not know how to do at this point