Re: How to make one file into many and download into CSV TXT files

To answer Booth's questions.

Up to 10,000 records in the original file.

At the present that data would be in groups of up to 60 different M2RUN
values.

There could one record is with an individual M2RUN value or perhaps 250
records with the same
M2RUN value.

There is no standardized list of sorted categories.

End result would be 50 to 100 CSV files.

For Alan's question there is only one field this file is sorted on - M2RUN.
All other values can be different, but they tend to be the same.

We are building files to input into a computer directed SAW to cut pieces
of wood specific lengths.



On Mon, Jan 5, 2015 at 4:55 PM, Booth Martin <booth@xxxxxxxxxxxx> wrote:

Can you add some texture to this? I am not clear as to what is happening.
-How many records are typically in the original file?
-Why is the file being sorted?
-Is the end result one .csv file or 50 to 100 .csv files?
-There are 50 to 100 sort fields or 50 to 100 records per sort category?
-Is there a standardized list of 100+ sort categories that do not normally
change from day to day (like a sorting by a list of store locations) as
opposed to sorting by date or by volume.)


On 1/5/2015 2:56 PM, Thomas Burrows wrote:

Hi:

Is there a quick way to take one file that is sorted and break into many
files according to the sort value? Then quickly download to a CSV TXT
file.
Know how to do this in general, but each day there will be an unknown
number of individual sort fields. Usually under fifty but could be maybe
75
to 100.

Hoping for a quick solution than the rather hard solution I am thinking
of.

Thomas

--

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.