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

Have to generate a file that we take some information and mix it in with
some set literals.

Then there will be a separate record in the TXT file for each record in the
PF file.

Have never done the create TXT file process before. Do you have any
examples?

On Mon, Jan 5, 2015 at 5:52 PM, Alan Campin <alan0307d@xxxxxxxxx> wrote:

So if I am understanding you correctly, you are level breaking each time
that the M2RUN value changes or do you call the program with M2RUN value as
a parameter? In other words, are all the M2RUN values run each time?

Seems easy enough to break at each M2RUN value and open a new text file,
write the data straight to it, then close it and open a new file for the
next one. One simple solution might be to run a Group By the M2Run value
and pass to a procedure. Each procedure would open a text file, read all
the records for a given M2RUN value and then close text file.

What type of manual massaging do you need to do?

On Mon, Jan 5, 2015 at 4:16 PM, Thomas Burrows <
thomas.burrows.1957@xxxxxxxxx> wrote:

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.

--
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.

--
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.