in reply to create separate output files based on name

How many companies do you have in total?

Are all the records for one company grouped together or are they mixed? If they are mixed, can you sort them on the company name prior to processing?

Depending on the answers, the solution might be extremely easy or (very) slightly more complicated.

  • Comment on Re: create separate output files based on name

Replies are listed 'Best First'.
Re^2: create separate output files based on name
by rruser (Acolyte) on Dec 18, 2013 at 20:29 UTC

    the records are grouped randomly but I can sort them by company, the number of companies can vary month to month however usually less that 12.