ADF Component ExportCollectionActionListener CSV File's Delimiter Is Not Always A Comma (Doc ID 2911144.1)

Last updated on NOVEMBER 23, 2022

Applies to:

Oracle JDeveloper - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

ADF Component exportCollectionActionListener CSV file's delimiter is not always a comma. For some users the CSV file is coming with semicolons instead of commas in an ADF component application that uses the exportCollectionActionListener with type="CSV" to download data from an ADF table and export it to an csv file, it shows that the fields are separated with ; instead of , such as:

"ViewAttr1;""ViewAttr2"";""ViewAttr3"";""ViewAttr4"";""ViewAttr5"""

This will cause an issue when the csv file is opened in Excel since it will not be read correctly

EXPECTED BEHAVIOR
-----------------------
When exporting data from ADF to CSV, the data should be separed with , (comma) like the following:

"ViewAttr1","ViewAttr2","ViewAttr3","ViewAttr4","ViewAttr5"

Cause

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Symptoms

Cause

Solution

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

ADF Component ExportCollectionActionListener CSV File's Delimiter Is Not Always A Comma (Doc ID 2911144.1)

Applies to:

Symptoms

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!