My Oracle Support Banner

Fusion Global HR: How to Remove Extra Lines in the Comma-Separated Values (CSV) Output from an HCM Extract Caused by a Line Break in the Description Field that Wraps the Data to a Second Line (Doc ID 2334326.1)

Last updated on AUGUST 25, 2020

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.20.04.0 and later
Oracle Fusion Global Human Resources - Version 11.12.1.0.0 and later
Information in this document applies to any platform.
This note was created for Release 11.1.11.1.0. The note has been reviewed and is current for release 11.13.20.04.0.

Goal

When using HCM Extract to export open text fields, line breaks cause the export file to wrap.  In cases where users may have pressed Enter within an open text or description field, that data will not export properly into line based delimited files such as comma-separated values (".csv").  How can these values be removed during the HCM Extract process?

Solution

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
Goal
Solution
References


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