on 04-12-2014 3:15 PM
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 | " |
Hi Abhishek
Does your content conversion work for the filed value ""Citrix Systems, Inc."" with
NameA.enclosureSign
NameA.enclosureSignEscape
I have tried but it is throwing error because it is treated Citrix Systems, Inc. as two fields
But if I provide the field value is "Citrix Systems, Inc." then it works perfectly.
Can you please tell me how it it is working for ""Citrix Systems, Inc.""
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Simple and better way to deal with it that you use generic FCC and then replace " with blank space in mapping using replace string .
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Abhishek ,
It wont fail at all.I have just checked the same with following fcc parameters.The fields will be populated in the payload with inverted comma like "Field1" .
Name | Value |
Records.fieldNames | Field1,Field2 |
Records.fieldSeparator | , |
Records.additionalLastFields ignore
Records.keepIncompleteFields YES
ignoreRecordsetName | true Thanks |
Hi Abishek
You can use Records.enclosureSignEscape = ""
- NameA.enclosureSignEscape
Specify a string that replaces the text delimiter if it occurs within a text that it delimits.
When the text is transferred the string is replaced by the value specified in NameA.enclosureSign.
Rgds
Eng Swee
Message was edited by: Eng Swee Yeoh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.