Flat File Splitting on Field Value Change

Home Page Forums BizTalk 2013 & BizTalk 2013 R2 Flat File Splitting on Field Value Change

Viewing 2 reply threads
  • Author
    Posts
    • #27990

      I have a schema with the header and line info combined in the same line.  There may be multiple ‘orders’ in the same file and i need to create a separate file for each ‘order’.

      How would i go about doing this?

      Sample data.  The identifier is ‘PC’ and is the same on everyline.  The field that has data starting with ‘AM’ is the order number field.  When the order number changes, i need to split the file.

       

      PC^A^CUSTOMER^AM111977^^A002^201986985

      PC^A^CUSTOMER^AM111978^^A003^201990030

      PC^A^CUSTOMER^AM111978^^A003^201986986

      PC^A^CUSTOMER^AM111979^^A004^201986987

      PC^A^CUSTOMER^AM111979^^A004^201986987

      PC^A^CUSTOMER^AM111979^^A004^201986987

    • #28033

      Flat file has two type 1) delimited and 2) positional. you have to use any of these. otherwise write own custom code…

    • #28034

      Hi.

      I would split it in an Orchestration. I mean in an Orchestration I would consume an external assembly wihich will split this file into seperate files give it back for further processing.

      • #28052

        You can write a custom flat file disassemble component which can split your file as per your requirement.

Viewing 2 reply threads
  • The forum ‘BizTalk 2013 & BizTalk 2013 R2’ is closed to new topics and replies.