My Oracle Support Banner

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 APRIL 01, 2019

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

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
References


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