cancel
Showing results for 
Search instead for 
Did you mean: 

Sender FCC parameter (fieldSeparator) Issue

former_member460664
Participant
0 Kudos
312

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.

Accepted Solutions (0)

Answers (3)

Answers (3)

apu_das2
Active Contributor

Hi Ashok,

This is normal behaviour of FCC that it will split data as per field separator. If you have mentioned comma as field separator then no data should contain the same else it will create issue.

You have 3 options -

1) Tell you file sender system to provide a separate field separator like pipe (|) if comma is not possible to avoid as a data.

2) Tell your file sender system to include double quote on each data line "ABC", "DEF", "asd, eee,rrr". and you configure FCC accordingly.

3) If above mentioned 2 is not possible to set from sender end and you are confirmed that only last field will contain comma then simply add one more field in your Data Type. So, last 2 fields will contain actual data of last filed. In MM concat these 2 and send to the target system.

Thanks,

Apu

former_member460664
Participant
0 Kudos

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.

former_member460664
Participant
0 Kudos

Hi Das,

Thank you for your quick response.

Hi All,

Any other solutions to achieve this requirement.

Regards,

Ashok.