My Oracle Support Banner

E-FL: CSV File Layout Load Data with Double Quote as Part of Data (Doc ID 2929549.1)

Last updated on SEPTEMBER 02, 2024

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.59 and later
Information in this document applies to any platform.

Symptoms

The sample site is on Peopletools  8.59 version.

CSV File Layout loads data with double quote and not remove double quote.
 
The issue can be reproduced at will with the following steps:

1. Login to Application Designer and then create a new File Layout by New > File layout > Insert Record > Select VOUCHER.

2. Open the Properties and select double quote as qualifier.

3. Create a test csv file.

4. Go to the Preview Tab > Browse to select the csv file.

5. Load the data and observe data having double quote.


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.