I present my users with a large table control (about 30 columns x 100 rows) that contains alphanumeric data in some columns (such as sample ID's), a date/time in another, and various floating point values in other columns. My users would like to be able to click on a column header and have the table sorted on that column. Very standard behavior.Sort 2D Array won't work here, I think, especially for numeric values in text format. It seems to me that I have to know what kind of data is in the selected column, convert it to doubles if necessary, sort the 1D array, and then reorder the table rows accordingly, either by keeping track of the sort order as I sort, or searching for each sorted item in the original array. That's all pretty straightforward, but a bit laborious. Not to mention the problem that LV will sort A12 before A3 in an alphanumeric sort, which is not what I'd like. I'm told that .NET controls will do some of this work automatically, but failing that is there a standard way of approaching this? It seems like a problem that would be encountered pretty frequently.

It's probably sufficient just to check for error and switch mode when an error occurs: You might want to implement some error handling to ensure that all fields were processed with the same algorithm. (not shown).

Sorting a Table

Hmmm

I'm confused. Supposedly, if you interpret the 64 bits of a double FP as a 64-bit signed integer, it will sort correctly.

But I observe this:

What am I missing?

Message 31 of 33

(38 Views)

I haven't studies it in detail, but it might have to do with the fact that negative integers are in Two's complement.

LabVIEW Champion.

Message 32 of 33

(30 Views)

In both Double, and I64, the MSB is 1 for negative, 0 for positive.

Message 33 of 33

(18 Views)

LabVIEW

Sorting a Table

Re: Sorting a Table

Re: Sorting a Table

Re: Sorting a Table