Cancel
Showing results for 
Search instead for 
Did you mean: 

Sorting real values in tablefile

Experimenter
Experimenter

Hi, I have a problem sorting real values in a tablefile.

 

The problem is not linked to the sort method directly (<Path>.sort(SortOrder:<any>); this works OK for me).

It is linked to the number of digits considered in sorting. It seems that only 6 digits are considered in sorting. For example, 0.1234567 and 0.1234568 are not considered to be different in sorting a column. In my case these numbers represent processing times, to be sorted according to a shortest processing time rule. Precision is important here.

 

Anybody having similar type of problems?

4 REPLIES

Re: Sorting real values in tablefile

Phenom
Phenom

I've checked with v11 and v13. Both versions  sort real numbers with 8 or more digits correct.

 

Therfore pls send your spp-file containing the tab-object with the real-numbers to be sorted

 

 

Re: Sorting real values in tablefile

Siemens Phenom Siemens Phenom
Siemens Phenom

Hi D-J,

 

Up to version 13 only 6 digits after decimal point are considered for sorting.

 

For single column sort in version 13 the exact numbers are compared.

 

@simulator: Could you please redo your test with V11?

Just try to sort a real column with the following numbers in V11:

0.123456789
0.1234567
0.1234568
0.1234567
0.1234568

Regards,

Ralf
------------------------------------------------------------------------------------------------------
Did you like the answer? Then click the Thumbs Up button.
Did the answer solve your problem? Then accept the answer as solution.

Re: Sorting real values in tablefile

Experimenter
Experimenter
Dear Ralf,

I just tried a simple workaround: multiplying values in the table by 100
and next sorting.

For this specific case it solves issues.

Thanks for your efforts and information.

D-J.

Re: Sorting real values in tablefile

Experimenter
Experimenter
Dear Ralf,

I just tried a simple workaround: multiplying values in the table by 100
and next sorting.

For this specific case it solves issues.

Thanks for your efforts and information.

D-J.