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 OCTOBER 04, 2022

Applies to:

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

Changes

Cause

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