Using Field Separator From Mapping:Receiver FCC

[Former Member]

Hi,

Is there any way that I can use field separator using the data from payload.

For Ex:

Consider the target structure:

MT

File

Field

Now if 'Field' has abcdefU1234, I want abcdef to come in one line and 1234 in the next line. Is it possible to handle this in FCC?

Thanks,

Vishal

[Former Member]

HI Vishal,

I understand that you would like to get abcdef in one and 1234 in another line in the target file.

Yes, this can be achievable. If the length of the field are pre-defined then we can do it.

Thanks

[Former Member]

Hi Hareen,

Actually the requirement is a little complex.

Will explain the actual structure.

MT

Root(0..unbounded)

Header(1..1)

Detail(1..unbounded)

Control(1..1)

Now a fixed length(100) of detail has to come in one line and next 100 in next line.

Are you saying if i mention the fix length it'll work?

Payload:

BatchHeader

123456789.....abcdef.........

abcdef...........1234567........

BatchControl

If i mention fix lengths will it come as

BatchHeader

123456789........

abcdef........

abcdef.......

1234567.....

Thanks,

Vishal

[former_member200962]

Handling it in mapping will be better I think.

[Former Member]

Vishal,

If you apply fixedlength for individual field along with a field separator as 'nl", then the outcome will be

Payload:

123456789.....abcdef.........

abcdef...........1234567........

Outcome:

123456789........

abcdef........

abcdef.......

1234567.....

Thanks,

[Former Member]

Sorry the structure i've mentioned is not displayed properly.

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_ABC xmlns:ns0="abc:def:dummy">

<file>(0..unbounded)

<Header></Header>(1..1)

<detail></detail>(1..unbounded)

<Control></Control>(1..1)

</file>

</ns0:MT_ABC>

Consider the above structure:

With field separator as 'nl'. The output will be

Header record

detail record(containing 2 parts for Ex: A+B)

.

.

.

detail record

Control record

Now the requirement is:

Header record

detail record A

detail record B

.

.

.

.

detail record A

detail record B

Control record

How can this be achieved? Where detail record A and B should appear as pair.

Thanks in advance,

Vishal

[Former Member]

Hi Vishal,

As per the requirement specified, we can achieve this using mapping.

Input Field> Remove context>Concat(if you would like to concat)--> Outout field

Regards,

[Former Member]

Sorry I did not get you.. Are you mentioning that I need to use one more mapping to reduce the heirarchy? The output that I have mentioned is already the output of second mapping!! I did it so as overcome receiver FCC constraints.

Thanks,

Vishal

[Former Member]

There is no need to do another mapping. To overcome the FCC constraints, use the functions in your mapping.

Can you please explain me what you have done?

Regards,