how to handle when comma and double quotes altogether in CSV file while importing in Informatica

user_14486714 0
Viewed 295

I have vendor SQL table which column value as :

131 Maker Tower, "F", Premises

While exporting in CSV from Informatica , following value is generated: ,

"131 Maker Tower, "F", Premises",

But when I read into the Informatica for importing into other table using CSV : It just fails as it read this into 3 different columns as comma is delimiter.

  • Column 1: 131 Maker Tower
  • Column 2: F
  • Column3: Premises

We want to export such that it is readable to business so can't use complex delimiter like *, or || etc.

informatica-cloud informatica etl csv sql
2 Answers

If informatica is trying to read a file which looks like this,

"131 Maker Tower, "F", Premises",

then use below properties optional quotes = Double Quote

enter image description here

Now, if this doesnt work, (because i havent tested this with this many double quote inside a string). The workaround would be, when you read from your first process, create a new file with new delimiter(like pipe) for intoamtica only. This will not be used by business. You can use this as your source file - it will work smoothly.

user_64305230

The problem is the wrong output. A right export for CSV is

"131 Maker Tower, ""F"", Premises"

If you import it, I think you will have only one field, containing 131 Maker Tower, "F", Premises

user_7577140
Related