When Multiple Lines Text Data In A Form Is Exported To CSV, It is Divided In Multiple Lines And Makes CSV Incorrect.
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.
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:
Test, "BaseData, FY14, Actual, Working, 410, P_000", Plan1
Text1, Test, "BaseData, FY14, Actual, Working, 410, P_000", Plan1
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