E-FLO: Excel Creates CSV File with Double Quotes Around Quoted Data (Doc ID 754349.1)

Last updated on OCTOBER 01, 2015

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.4 and later
Information in this document applies to any platform.
***Checked for relevance on 17-Apr-2014***


Symptoms

When loading data created using Excel on PeopleTools 8.4x, if one or more fields contain data with quotes around it, the saved CSV flat file  shows quotes around the field and double quotes around the quoted portion of the string.

Sample Raw Data;

the "note" is quoted
note is not quoted X

Resulting Excel formatted CSV file Data;

"the ""note"" is quoted"
note is not quoted X

When attempting to use File Layout and Application Engine to load the above data into a 20 Character field, the following error occurs:

ERROR
-----------------------

The value of RECORD.DESCR20 is '"the ""note"" is quoted"', which is longer than RECORD.DESCR20. (15,78)
Message Set Number: 15
Message Number: 78
Message Reason: The value of RECORD.DESCR20 is '"the ""note"" is quoted"', which is longer than RECORD.DESCR20. (15,78)

Error copying fields. (2,722) AEPROGRAM.MAIN.GBL.default.1900-01-01.Step01.OnExecute Name:ImportSegment PCPC:1867 Statement:30 Called from:AEPROGRAM.MAIN.GBL.default.1900-01-01.Step01.OnExecute Statement:66
Message Set Number: 2
Message Number: 722
Message Reason: Error copying fields. (2,722)

Process 8466 ABENDED at Step AEPROGRAM.MAIN.Step01 (PeopleCode) -- RC = 8 (108,524)
Message Set Number: 108
Message Number: 524
Message Reason: Process 8466 ABENDED at Step AEPROGRAM.MAIN.Step01 (PeopleCode) -- RC = 8 (108,524)

REFER TO ATTACHED GSC-RecreatesError.doc

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