My Oracle Support Banner

WebADI Includes Double Quotes Around Quoted Data After Loading csv Format File (Doc ID 2000891.1)

Last updated on FEBRUARY 07, 2019

Applies to:

Oracle Web Applications Desktop Integrator - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Goal

Created a Custom WebADI integrator and when defining the content, select the "Web ADI: Download "Text File" Parameters" as the parameter list.
When uploading from a CSV file, one can specify the delimiter (comma).  When the data loads into the upload sheet, it includes the " text delimiters, for example "field1","field2" loads into the cells as "field1" and "field2".

How to get WebADI to treat the text delimiters correctly (ie not import the "" into the spreadsheet cells)?
 

Solution

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
Goal
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.