I have a standard (in that I can't change it) output file from a system. Unique rows are identified by the "group" and "time" columns, examples of these are: Iteration 1|ASL|NWPF|2_01, Iteration 1|ASL|NWPF|2_02 and time is just 0-480. I want to merge this output down (removing the final 01/02 split in the example group above) which with vfp7 I could easily do with select * and group by group, time even if with my limited knowledge I had to do with a cusror and then overwriting the group field to the unique part). I don't want to list every field (there are about 4 more text fields but they're the same on every record and around 150 numeric fields but these could change and I don't want to update this grouping code every time the output changes because the odds are someone would forget and it would break.
Thanks for the help!
Thanks for the help!