You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 10
Next »
REMDOUBL# returns a Telitab subset from which multiple ocurring cases are removed
Syntax
- REMDOUBL#(Mode%, Telitab$,Deviation,[ArgPar_1$,..,ArgPar_n$])
- REMDOUBL#(Telitab$,[ArgPar_1$,..,ArgPar_n$])
Arguments
- Mode% is the way you want to remove or use double values:
- Mode% = -2 inverse remove, will only leave the double values, keeping Deviation into account
- Mode% = -1 standard remove of double values, removing all double values, keeping Deviation into account
- Mode% = 0 standard remove of double values, leaving one case (the very first one...), keeping Deviation into account
- Mode% > 0 standard remove of double values (comparable to Mode% = 0 ) but returning only the column with a number equal to Mode%, keeping Deviation into account
- Telitab$ is a string expression containing table to be analysed.
- Deviation is a very small value required for instance in order to compensate errors due to internal rounding
- ArgPar_1$,,,,ArgPar_n$ is an optional list of parameter names in Telitab$ to base the REMDOUBL# on.
- By means of the Mode% in combination with Deviation, you are able to get specific sections from a dataset.
- By standard (second syntax) any second case of a table for which the values of ArgPar_1$,,,,ArgPar_n$ are the same, is removed from the table.
- If ArgPar_1$,,,,ArgPar_n$ is void, all parameters in the table should have the same value as in any previous case in order to be removed from the set.
Examples
When we use the relation:
REMDOUBL#(Telitab$, "SPEED", "RPM")
for Telitab$:
0
6 "RUN" "SPEED" "RPM" "TORQUE" "THRUST"
"1" 5607401001 0.00 803.00 132.27 -39.32
"2" 5607401002 0.35 835.69 133.02 -39.08
"3" 5607401003 0.70 877.99 135.47 -39.23
"4" 5607401004 1.39 903.04 118.85 -32.78
"5" 5607401005 0.35 835.69 133.02 -39.08
"6" 5607401006 2.10 902.16 92.47 -23.55
"7" 5607401007 0.35 860.41 133.02 -39.08
Will return:
0
6 "RUN" "SPEED" "RPM" "TORQUE" "THRUST"
"1" 5607401001 0.00 803.00 132.27 -39.32
"2" 5607401002 0.35 835.69 133.02 -39.08
"3" 5607401003 0.70 877.99 135.47 -39.23
"4" 5607401004 1.39 903.04 118.85 -32.78
"5" 5607401006 2.10 902.16 92.47 -23.55
"6" 5607401007 0.35 860.41 133.02 -39.08
Case 5 (row 5) is removed because SPEED and RPM are the same as in case 2.
Please note, REMDOUBL#(Telitab$) would return the complete Telitab$ as result due to the difference RUN numbers (also for cases 2 and 5).
Quick links: Function overview | Attribute overview | Constants overview | Dimensions overview