cancel
Showing results for 
Search instead for 
Did you mean: 

one record data is give ,is it possible to send into xi & split

Former Member
0 Kudos

hi,

only one record data is given

ex: 123prlree2345sdrljlf.

is it possible to send this data into xi &

mapp with header, body,trailer ?

thanks in advance.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Yes u can do it in message mapping,

U have substring option if u know the string lenght then u can do this.

u can write the UDF for spliting the string into header,boby and footer part.

Regards,

Phani

Answers (4)

Answers (4)

Former Member
0 Kudos

A small doubt.

on wat condition should the record be spliited?if any pls specify?

Former Member
0 Kudos

thank u

Former Member
0 Kudos

Hi,

What you can do is - read the record in a single row using file content conversion and in you message mapping you can map it accordingly using substring() function. You can use two-step mapping if required. i.e. first mapping to convert single node to multiple nodes (header, data. trailer) and second mapping to do your actual mapping.

Hope this helps.

Regards,

Riyaz

Former Member
0 Kudos

Hi,

can u clarify your question??

If you passed a single line txt file then using FCC we can able to convert the record according to fields.

Like your recuirement Header,Body,Trailer.

*Reward Points If Useful*

Regards,

Prakasu

Former Member
0 Kudos

hi,

using UDF you can split the string and do this.

Thanks,

Madhu