in reply to Re^5: File read and re-ordering
in thread File read and re-ordering

Sir, Field 2 contains a static text that my company will imput for each record, field 3 is the same, as with field 4. Field 5 is blank. Field 9 and 10 are blank as well. Field 13 and 14 used to contain data but is being suspended for this run so will contain blanks. So all of those other than 2, 3 and 4 should be space filled. Field 11 you are correct, I mis-spoke earlier, I had assumed it was seperate but as I looked into it I noticed it is all one line. My apologies! And it is one header file where each line is a customer record, and one detail file for all records where starting line is 0. Again I apologize for the miss communication for field 11.

Replies are listed 'Best First'.
Re^7: File read and re-ordering
by johngg (Canon) on Oct 23, 2006 at 19:47 UTC
    Great, I think I have all the info now. No need to apologize about field 11, easy slip to make with such complex data :)

    I will spend a bit of time digesting all of the information and try out one or two ideas then I'll make suggestions, probably in another reply to the OP.

    Cheers,

    JohnGG