Double Quotations in FCC

[umesh_badveli]

Hi All

I am doing File to Sftp Scenario

Sender side iam getting data in Double Quotes

"A","acbc","xyz"

FCC parameters i maintained in CC

subnode.filedNames: 

subnode.filedSeparator: ","

subnode.filedSeparator: 'nl'

subnode.beginSeparator: "

subnode.enclosureSign: "

Still  I am unable to read the file at sender side.

any parameters I am missing ?

Help me out in this issue

Thanks in Advance

Umesh

[Former Member · Accepted solution]

Hi Umesh,

Please follow the below FCC parameters for your requirement.

Regards,

Rajendar

[umesh_badveli · Accepted solution]

Hi Rajendar

Thanks for your answer

But there is small problem in xml payload its not taking the last element in sender file

[Former Member]

Hi Umesh,

Please check the that  filed Spelling and any Spaces in text file.

Regards,

Rajendar

[umesh_badveli]

Hi Rajendar

Problem was Solved but it not Spelling Issue

I changed the Parameter from subnode.endSeparator  : "'nl'  to

                                                            subnode.endSeparator  : 'nl'

Thanks for your reply and Thanks all

Regards

Umesh

[former_member208396]

Hello,

please check below link. Hope you can get some idea from it.

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

Regards,

Vishnu

[tinu_n]

Hi Umesh,

Check if FCC is working with the below parameters,

subnode.enclosureSign  "

subnode.enclosureSignEnd  "

subnode.endSeparator  'nl'

subnode.fieldNames

subnode.fieldSeparator  ,

Also Please let us know the error message your getting.

Regards,

Tinu

[RaghuVamseedhar]

Umesh,

In this case, I think, beginSeparator is not required.

Please let us know the error message.

[Harish]

Hi Umesh,

Did you check the below link

File Content Conversion---> Removing Quotati... | SCN

regards,

Harish

[umesh_badveli]

Hi Harish

I saw that link Still Same only

Thanks

Umesh

[former_member186851]

Hello Umesh,

check the spellings and fieldSeparator repeated 2 times.I guess it should be endSeparator

subnode.filedNames: 

subnode.filedSeparator: ","

subnode.filedSeparator: 'nl'

it should be

fieldNames

fieldSeparator

endSeparator