WebADI Includes Double Quotes Around Quoted Data After Loading csv Format File
Last updated on AUGUST 08, 2017
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.
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)?
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