Re^5: File read and re-ordering

Not quite done with questions it seems.

Fields 2 - 5, 9, 10, 13 and 14 don't appear to have any data associated with them, should they be space-filled?

In this node you say that city/state/ZIP need to be split out but here the whole of line 7 goes into field 11 (offset 378). What gives?

Your fields at offsets 452 and 460 seem to mandate one header file and one detail file as output rather than separate detail files for each customer. Is the starting line offset into the detail file zero-based?

Cheers,

JohnGG

Comment on Re^5: File read and re-ordering

Replies are listed 'Best First'.
Re^6: File read and re-ordering by KarmicGrief (Initiate) on Oct 23, 2006 at 19:23 UTC
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.	[reply]
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	[reply]