Mail Attachment file content issue

[Former Member]

Hi Experts,

  Present the scenario is File to Mail , the source file will be in the form of EDI text and i have to attach this file by doing some modification to the mail . The problem here is , the data content in the source file will be as

UNB+UNOA:3+5013:14+50517:ZZ+130710:1723+7++OG++++1'UNH+700002+OG:D:963A:UN:'BGM+230+1040+4'DTM+4:20130701:102'DTM+137:20130701:102'DTM+64:20130726100000:204'DTM+63:20130726100000:204'DTM+200:20130701:102'FTX+AAB+++28 Days, Discount 0%'FTX+COI+++ATTN?

and the target data content of attachment file must be like

UNB+UNOA:3+5013:14+50517:ZZ+130710:1723+7++OG++++1'

UNH+700002+OG:D:963A:UN:'

BGM+230+1040+4'

DTM+4:20130701:102'

DTM+137:20130701:102'

DTM+64:20130726100000:204'

DTM+63:20130726100000:204'

DTM+200:20130701:102'

FTX+AAB+++28 Days, Discount 0%'

FTX+COI+++ATTN?

i.e. for each apostrophe (i.e. ' ) data has to be separated in new line .

i think of  using Message TransformationBean  in the receiver mail adapter and could any one help me what are the parameters that has to be used .

Thanks a lot.

Regards,

Yugandhar

[ambrish_mishra]

Hi Yugandhar,

Are you doing mapping in PI for this ?

If yes, while populating content field in the mail API, replace apostrophe with apostrophe+CRLF.

Hope it helps!

Ambrish

[Former Member]

Hi Ambrish,

Thanks for reply ,

But the problam is we haven't created ESR part . we are passing the same file that we got from FTP server . so that we are using Message TransformationBean in Receiver mail adapter.

  the parameters that used are ,

  Parameter  Name                               value

Transform.ContentDescription             EDI

Transform.ContentDisposition            inline

Transform.ContentType                     text/xml;charset=utf-8

  xml.conversionType                          SimpleXML2Plain

xml.fieldSeparator                              '

Regards,

Yugandhar