Marketing List Import - Double Quotes Interfering with CSV File Delimiter (Doc ID 2452424.1)

Last updated on MAY 18, 2021

Applies to:

Goal

Requirement is to import a CSV file into List (Prospect) by using 'Administration - Marketing' -> 'Import'

where csv file contains double quotes enclosing the field data. Such as:

First Name,Last Name,Gender

<SSS>,<BBB>,<M>

After import, the First Name in Siebel was saved as: "SSS","BBB"

Last Name was saved as: "M"

How to import a CSV file into Marketing List Prospect when input data fields are enclosed within double quotes?

 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.