Skip to Content
0

Sender FCC parameter (fieldSeparator) Issue

May 19, 2017 at 09:50 AM

30

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Apu Das May 19, 2017 at 10:40 AM
1

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

Share
10 |10000 characters needed characters left characters exceeded
Ashok Kumar Jun 13, 2017 at 05:55 AM
0

Hi Das,

Thank you for your quick response.

Hi All,

Any other solutions to achieve this requirement.

Regards,

Ashok.

Share
10 |10000 characters needed characters left characters exceeded
Ashok Kumar Jun 13, 2017 at 06:03 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded