apache626 (9/27/2012)
I have a flat file with trailers that the total the amounts in certain columns. I need to import the trailer into a different table. How can I split the data so that I can put the trailer data into a different table. Here is the sample data below:1002AMickey Mouse500.0025.00ACMECORP 1000.00
1002BDuck Donald 125.00 15.00 ACMECORP 2500.00
1002T Doe Jane 750.0020.00ACMECORP 2300.00
1002 1375.0060.00 5800.00 2010
10036740.5675.007800.23 2011
Try using conditional split.
However please provide more input for more assistance e.g.
1. What is the trailer part in above example ?
2. Is there any fixed pattern or length for this ?
3. Logic behind trailer generation in more detail.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂