FCC Issue

[Former Member]

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	"

[Former Member]

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

[Former Member]

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.

[Former Member]

Hi Anshu ,

This will not solve the issue , as the error we get in sender channel only . It does not reach to mapping for applying your logic .

[Former Member]

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

[engswee]

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.

Converting Text Format in the Sender File/FTP Adapter to XML - Configuring the File/FTP Adapter in I...

Rgds

Eng Swee

Message was edited by: Eng Swee Yeoh