Hi experts ,
we are having a file to proxy scenario where we are expecting a CSV file (comma as delimiter) along with the fields enclosed in " ".
But in the source file there are certain records which has ""field value""
""Citrix Systems, Inc."","Citrix","695874","Teresa","Abel","ACTIVE"
""Citrix Systems, Inc."","Citrix","695874","Teresa","Abel","ACTIVE"
""Citrix Systems, Inc."","Citrix","695874","Teresa","Abel","ACTIVE"
""Transocean, Inc."","Transocean","716850","Jason","Raynes","ACTIVE"
""Transocean, Inc."","Transocean","719215","Ronald","Dailey","ACTIVE"
the client has said there is possibility of these kind of data to come in PROD , can you suggest how to deal with it or any pointer .
Our current FCC parameters are
Header 1 Header 2 ignoreRecordsetName True Records.fieldSeparator , Records.endSeparator 'nl' Records.fieldNames ClientLongName,ClientShortName,AsigneeID,AsigneeFirstName,AsigneeLastName,ActiveInactive Records.enclosureSign "