title: BizTalk mapping RECADV D96A
body: <p>I need to convert the CSV file to EDIFACT RECADV D96A.</p>
  
  <p>The input:</p>
  
  <pre><code>REC;A;ABC;120769;4502902610;0196466358;ABC;;202003051329;OB:505+DP:8718
  RECD;1;110000;45;;  
  RECD;1;120000;50;;  
  RECD;1;130000;100;; 
  RECD;2;200000;21;;  
  RECD;2;210000;12;;
  </code></pre>
  
  <p>And the output should be:</p>
  
  <pre><code>LIN+1++1:EN'
  GIN+BJ+110000:45'
  GIN+BJ+120000:50'
  GIN+BJ+130000:100'
  
  LIN+2++2:EN'
  GIN+BJ+200000:21'
  GIN+BJ+210000:12'
  </code></pre>
  
  <p>This is what I managed to do until now:(take only first GIN for each line)</p>
  
  <pre><code>LIN+1++1:EN'
  GIN+BJ+110000:45'
  
  LIN+2++2:EN'
  GIN+BJ+200000:21'
  </code></pre>
  
  <p>How can I do to take the number for each distinct line?</p>
  
  <p>Thank you in advance!</p>