messagetransformbean - entire file to single element data

[sandip_hole]

Hello experts,

A quick question is it possible to dump entire txt file content to single element in xml structure using messagetransformbean?

file contains random data with multiple lines

File Data-

1x2x3xasdfghjkl123456zxcvbnm

adjolm123456nuklldr

1234688900qwertyuuii

asdf

1234

qwert

can i make it to xml structure like---

<Node>

<Data>

1x2x3xasdfghjkl123456zxcvbnm

adjolm123456nuklldr

1234688900qwertyuuii

asdf

1234

qwert

</Data>

</Node>

if yes,how can i achive this conversion using messagetransformbean?

[sandip_hole · Accepted solution]

separated the data in java mapping, as required.

Thanks,

Sandip Hole

[smavachee]

Another alternative method you can use, if you are below PI 7.1, you can refer

Whole Payload to a XML field

Or if you are using PI 7.1, find very well articulated blog by Jyothi Anagani at

Hope it help.!

Regards,

Sunil

[sandip_hole]

Thanks Sunil, but i want the entire file into single data element of xml. basically at sender adapter.

[smavachee]

Any specific requirement to have it at sender adapter itself ? if file with single element is expected at receiver end.

And even java mapping given by Shabarish will work in similar way, isnt.!

Regards,

Sunil

[gagandeep_batra]

hi sandip,

i am not sure but you can try to give the field separator as unique which is not in the file something spacial charater like(#,@,^...) , or give field separator as blank.

Regards

Gagan

[sandip_hole]

Even i thought of  handling using special charactors but by default it takes new line to next <Data> element, is there any way or parameter in messagetransformbean to egnore new line feed?

[sandip_hole]

i am able to transform to multiple each line <Data> elements, can i make it all lines to single <Data>