Need help to split flat file

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Need help to split flat file

Viewing 1 reply thread
  • Author
    Posts
    • #23627

      Hi All,

      I have just realised that, I need to create a separate file for every message and transform and send through Send port to SAP .As SAP accepts one file as one idoc.
       
      File comes like below:
       Service Provider: OGVG.DK-BLUEWATERMARINE Invoice Number: TEST4 Invoice Date: 02-SEP-2009 Request For Invoice Number: RFI-562 Amount: 50 Amount Liable To VAT: 0 Amount Tax-free: 50 VAT Rate: Currency: NOK Plant: NOR01 Invoice Id: SERVPROV.20090902-0004 Due Date: 10-SEP-2009
      Project: 123 Buy Shipment: OGVG.0110757 Buy Shipment Type: STANDARD Original Buy Shipment: Amount: 33.33
      Project: 124 Buy Shipment: OGVG.0110757 Buy Shipment Type: STANDARD Original Buy Shipment: Amount: 16.67 —————-Messsage-1 should create 1 file
       
      Service Provider: OGVG.DK-BLUEWATERMARINE Invoice Number: TEST5 Invoice Date: 02-SEP-2009 Request For Invoice Number: RFI-563 Amount: 150 Amount Liable To VAT: 18 Amount Tax-free: 132 VAT Rate: 25 Currency: EUR Plant: NOR01 Invoice Id: SERVPROV.20090902-0005 Due Date: 13-SEP-2009
      Project: 123 Buy Shipment: OGVG.0110757 Buy Shipment Type: STANDARD Original Buy Shipment: Amount: 100
      Project: 124 Buy Shipment: OGVG.0110757 Buy Shipment Type: STANDARD Original Buy Shipment: Amount: 50 —————–Messsage-2 should create 1 file
       
      Service Provider: OGVG.KN Invoice Number: TEST-RFI-701 Invoice Date: 23-SEP-2009 Request For Invoice Number: RFI-701 Amount: 100 Amount Liable To VAT: 0 Amount Tax-free: 100 VAT Rate: Currency: EUR Plant: NOR01 Invoice Id: SERVPROV.20090923-0001 Due Date: 24-SEP-2009
      Project: 12345 Buy Shipment: OGVG.0110800 Buy Shipment Type: STANDARD Original Buy Shipment: Amount: 100
      Project: 12345 Buy Shipment: SERVPROV.0100033 Buy Shipment Type: SECONDARY CHARGE Original Buy Shipment: OGVG.0110800 Amount: 100——Messsage-3 should create 1 file
       AND so on……………………..

      I need your help to split this file as many as Service Provider comes in input file.Please provide if some documentation/reference solution available with you or over web.
       
       Thanks in advance for your gracious help.
      Bhupal.

    • #23631

      Hi Bhupal,

       

         I recommend that you read through the following articles written respectively by Jeff Lynch and Stephen Thomas, on different approaches to splitting files in BizTalk:

       

      http://codebetter.com/blogs/jeff.lynch/articles/128664.aspx

      http://geekswithblogs.net/sthomas/archive/2004/12/12/17373.aspx

       

         Though these articles were written for BizTalk 2004, they are still relevant for version 2006. I hope these resources will help you in your project.

       

          Good luck,

       

          Daniel.

       

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