0
   

How do i parse this file

 
 
Reply Wed 19 Nov, 2014 12:45 pm
I have a flat file with parent child records parent record is identified by 01 and child records from 02 to 16. here is the layout.

010101ABC0001230412192L 01.... Parent1
02NAME...ADDRESS....01256389201419... CHILD1
03NAME...ADDRESS....01256389201419... CHILD2
010101ABC0001230412192L 01.... Parent2
02NAME...ADDRESS....01256389201419... CHILD1
03NAME...ADDRESS....01256389201419... CHILD2
04NAME...ADDRESS....01256389201419... CHILD3

and this is how I want it:
010101ABC0001230412192L 01…02NAME...ADDRESS....01256389201419
010101ABC0001230412192L 01.. 03NAME...ADDRESS....01256389201419
u sing C# in ssis
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Question • Score: 0 • Views: 663 • Replies: 0
No top replies

 
 

Related Topics

Windows update (SQL server) - Question by Walter Hinteler
 
  1. Forums
  2. » How do i parse this file
Copyright © 2024 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.03 seconds on 05/05/2024 at 04:38:17