Content Conversion Issue

[Former Member]

I am performing content conversion on a file in the file receiver adapter. Everything works well but one item. My xml is set up as

<ns0:MT_Delivery xmlns:ns0="http://abc.com">

<Header>

<BOF>$BOF 20111220</BOF>

</Header>

<BOB>

<BOB>

<BOBItem>$BOB</BOBItem>

<OH>

<record_type>OH</record_type>

<origin_code>1701</origin_code>

<order_no>0030001031</order_no>

</OH>

<ThreePICO>

<record_type>3P</record_type>

<party_code>C1</party_code>

<company_name>CHS INC</company_name>

<company_name2>Plant City Sales</company_name2>

</ThreePICO>

<RFPO>

<record_type>RF</record_type>

<reference_code>PO</reference_code>

<reference_dscr>A.05</reference_dscr>

</RFPO>

<RFCustPO>

<record_type>RF</record_type>

<reference_code>xs</reference_code>

<reference_dscr>A.05</reference_dscr>

</RFCustPO>

</BOB>

</BOB>

</ns0:MT_Delivery>

This is ~ delimited.

My content conversion data is set up as:

Recordset = Header,BOB,OH,ThreePICO,RFPO,RFCustPO

fieldNames for Header = BOF

fieldNames for BOB = BOBItem

fieldNames for OH = record_type,origin_code,order_no

fieldNames for ThreePICO = record_type,party_code,company_name,company_name2

fieldNames for RFPO = record_type,reference_code,reference_dscr

fieldNames for RFCustPO = record_type,reference_code,reference_dscr.

When my file is created, I get the following

$BOF 20111120

$BOB_OH1701~0030001031

3P_C1CHS Inc~Plant City Sales

RF_POA.05

RF_xsA.05

I don't understand while "$BOB" and "OH₁₇₀₁0030001031" all show up on the same line. I've even tried to force a new line using 'nl' after the BOB segment, but no luck. Any ideas?

[Former Member]

hi,

have you writen any udf for removing delimiter in mapping level?

thanks,