Importing Data Using a CSV File
Last updated on JULY 04, 2017
Applies to:Siebel Tools - Version 7.7.2  to 22.214.171.124 SIA [Release V7 to V8]
Information in this document applies to any platform.
When trying to import Account data from a .CSV file using a Custom Business Service, all data is being imported successfully, except when trying to read Account Name which is in this format ABC "Corp" Main.
The code used is:
var ofile=Clib.fopen("D:\\a.csv", "rt");
TheApplication().RaiseErrorText("Error in opening the file");
var array=new Array();
var a1= array
array holds Account Name: ABC "Corp" Main
When assigning a1=array instead of assigning ABC "Corp" Main it is assigned as "ABC""Corp""Main"
How to read the data as it is when data contains quotes("")?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms