12-28-2006, 06:48 AM
Hi Gindi et al,
1) I have a QM VARIANT array that is 3 columns and 50,000 rows
2) The first column is just a record number (ie, from 1 to 50,000)
3) I need to sort the entire array based on the second column, which is strings of width 0 to 100 characters.
4) Then I will perform an operation to populate the third column. This operation would be based on the strings in the second column.
5) Then I would like to resort the entire array based on the first column (ie, just put it back in record number order).
So....my overarching question is...does this sound doable (I would prefer not to export to Excel and then bring back into QM)...and if so, could you kindly kick me off with a little code?
I can't tell from the code in this post if I must glue all the columns together and sort on fixed positions, or if there is an easier way to work with qsort and arrays...or maybe that is the easy way
If possible, I just need to understand the essence of sorting a multi-column array based on one column. I don't see how to designate one column for qsort to operate on.
Thanks.
1) I have a QM VARIANT array that is 3 columns and 50,000 rows
2) The first column is just a record number (ie, from 1 to 50,000)
3) I need to sort the entire array based on the second column, which is strings of width 0 to 100 characters.
4) Then I will perform an operation to populate the third column. This operation would be based on the strings in the second column.
5) Then I would like to resort the entire array based on the first column (ie, just put it back in record number order).
So....my overarching question is...does this sound doable (I would prefer not to export to Excel and then bring back into QM)...and if so, could you kindly kick me off with a little code?
I can't tell from the code in this post if I must glue all the columns together and sort on fixed positions, or if there is an easier way to work with qsort and arrays...or maybe that is the easy way
If possible, I just need to understand the essence of sorting a multi-column array based on one column. I don't see how to designate one column for qsort to operate on.
Thanks.