Skip to Content
avatar image
Former Member

Content Conversion Issue

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

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

$BOBOH1701~0030001031

3PC1CHS Inc~Plant City Sales

RFPOA.05

RFxsA.05

I don't understand while "$BOB" and "OH17010030001031" 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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 21, 2011 at 04:34 AM

    hi,

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

    thanks,

    Add comment
    10|10000 characters needed characters exceeded