Open CSV parser
Please note the following for the Open CSV parser for sources.
For more information on the Opencsv specification, see https://opencsv.sourceforge.net/.
Single-line and multi-line CSV data
The Open CSV parser only supports single-line data.
To import multi-line data, you must use the RFC 4180 parser.
Open CSV flag
For Secure FTP sources created before the RFC 4180 parser was available, the default parser was the Open CSV parser. If you would like to select the RFC parser for previously created sources, you can follow the steps for Managing sources and edit the source to configure a new parser.
Example of an Open CSV file
Quotes and delimiters are used to separate items.
ID,"First name(s)","Last name"
5,"John James","Smith"
Supported delimiters
When configuring a source, the Open CSV allows you to select one of the available characters as a delimiter: comma (,), semi-colon (;), pipe (|), or tab( ).
You can also enter a custom delimiter.
When entering a custom delimiter, keep the following in mind:
- You cannot use the backslash or double quote characters.
- You must use a single character. You cannot enter multiple characters for the delimiter.
Special characters
Keep in mind the following for using special characters with the Open CSV parser.
- For strings with special characters, quotes are mandatory. For example, if a string has a comma, then you will need to quote the string: "Abc, 123".
- Escapes (backslash character) are optional.
- Backslash characters should always be escaped. For example, if there is a backslash in your data, use the following format: “\\ abc".
- To manage double quote characters inside a quoted string, insert a backslash before the quote inside the string: “Asd \” asd".
Importing empty or null data
-
To update the Oracle Unity data model with empty or null data, learn how to Different ways to represent empty or null data in source files.
-
Review the Restrictions on empty or null data.
Configuring the Open CSV parser with the Oracle Unity API
Review Open CSV File standards for the Oracle Unity API from the Oracle Unity Developer Help Center.
Review these resources to configure sources and ingest jobs using the Oracle Unity API from the Oracle Unity Developer Help Center.