Sender FCC parameter (fieldSeparator) Issue

[former_member460664]

Hi Team,

I have configured FCC parameters to read comma (,) separated file. Every thing is fine except for the last field. comma(,) is added to the last field as a value. This should not be happened. I have tried with many possibilities, but could not get the solution to avoid adding comma as a value to the last field. Your help is appreciated if any.

Regards,

Ashok.

[former_member460664]

Hi All,

Adding another point to my query. Comma(,) is added to the second last field and last filed is not at all include in the structure.

Ex: If I have 10 fields in the configuration... then I have 9 commas(,) in the actual CSV file. Lets assume no values are there for 8,9 and 10th fields. After reading the file, 8th filed did not have value but available in the payload. 9th field contains comma(,) as value. 10th filed is not at all generated in payload. How to overcome this?

Regards,

Ashok.