on 2017 May 19 10:50 AM
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.
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Das,
Thank you for your quick response.
Hi All,
Any other solutions to achieve this requirement.
Regards,
Ashok.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
48 | |
9 | |
8 | |
6 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.