convert to flat file

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › convert to flat file

Viewing 1 reply thread
  • Author
    Posts
    • September 19, 2013 at 2:14 AM #26157
      community-content

        Hi all,

        I have a x12 850 file please see below sample:

        %ufeff%ufeff%ufeff%ufeff%ufeffPO1*1***45.56**IN*20077
        PID*F****Keurig K10 Mini Plus Black with K-Cups
        SCH*2664*EA***005*20130912*****1*1
        SCH*150*EA***005*20130910*****2*1
        PO1*2***45.56**IN*20079
        PID*F****Keurig K10 Mini Plus Red with K-cups
        SCH*2664*EA***005*20131005*****1*2
        SCH*20*EA***005*20131002*****2*2

         

        how can i convert it to flat file like:

        POITEM,20077

        SCHITEM,2664

        SCHITEM,150

        POITEM,20079

        SCHITEM,2664

        SCHITEM,20

        PO1*1***45.56**IN*20077
        PID*F****Keurig K10 Mini Plus Black with K-Cups
        SCH*2664*EA***005*20130912*****1*1
        SCH*150*EA***005*20130910*****2*1
        PO1*2***45.56**IN*20079
        PID*F****Keurig K10 Mini Plus Red with K-cups
        SCH*2664*EA***005*20131005*****1*2
        SCH*20*EA***005*20131002*****2*2
      • September 19, 2013 at 11:39 PM #26159
        community-content

          anyone can help me?after i convert to flat file it become like this:

          POITEM,20077

          POITEM,20079

          SCHITEM,2664

          SCHITEM,150

          SCHITEM,2664

          SCHITEM,20

      • Author
        Posts
      Viewing 1 reply thread
      • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.