Marketing Import: CSV File when Comma is part of the field data. (Doc ID 2424311.1)

Last updated on JULY 09, 2023

Applies to:

Goal

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

where csv file is comma delimited.

Below shows a sample csv content (with header and 2 records)

FirstName,LastName,Email,
'ABC,FirstName','ABCLastName','ABCmail@abc.com',
'XYZ,W','XYZLastName','XYZmail@abc.com',


How to import a CSV into List Prospect when the Name field contains the delimiter character - in this case a comma itself?
 

Solution

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