FCC options for multiple record structures

[Former Member]

Hi all.

Please give me solution If one file contains multiple record structures and combination of field seperators.How can we do it by using FCC.

Example:

apple,1234,AAA,BBB|ZZZZ|KKKKK|MMMM|KKK

ssssssss,ssssss,

eeeee|rrrrrrr|6666666|777777777777|99999999999|000000000|

ball#cat#mmmm#table#

[madhusudana_reddy2 · Accepted solution]

Hi,

You first line(apple,1234,AAA,BBB|ZZZZ|KKKKK|MMMM|KKK) showing two different field separators so it is not possible to do in FCC. For every structure you should have a single field separator either | or # etc.

This you can still handle in Mapping. If you use file content conversion with field separator | and keyfield value as ZZZZ then data will come to mapping like below

<field1>apple,1234,AAA,BBB<field1/>

<keyfield>ZZZZ</keyfield>

<field3>KKKKK</field3>

<field4>MMMM</field4>

<field5>KKK</field5>

so now you can split field1 based on , by using UDF in Mapping to map it to different fields of target structure.

Below lines is very easy to handle in Sender channel fcc by using keyfield value (ssssss or 6666666) and field separator(| or , etc) combination.

ssssssss,ssssss,

eeeee|rrrrrrr|6666666|777777777777|99999999999|000000000|

ball#cat#mmmm#table#

Please let me know if you need more clarification

Thanks,

madhu