When Multiple Lines Text Data In A Form Is Exported To CSV, It is Divided In Multiple Lines And Makes CSV Incorrect.

(Doc ID 2230503.1)

Last updated on SEPTEMBER 19, 2017

Applies to:

Oracle Planning and Budgeting Cloud Service - Version 16.12.53 and later
Information in this document applies to any platform.

Symptoms

When multi-line text is entered as data and export it from a job, the data is divided into multiple lines in the exported file.
For example, You have two text type data on a form Text1 and Text2 as shown below:

You enter multiple lines text in Text2 and single line text in Text1 as shown below:

Then you try to export the data to CSV in the following steps:

You will find that the multiple lines text data in Text2 is divided into multiple lines in a CSV file as shown below:

Text2, Test
Test, "BaseData, FY14, Actual, Working, 410, P_000", Plan1
Text1, Test, "BaseData, FY14, Actual, Working, 410, P_000", Plan1

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms