@Subset
Syntax
@Subset(FN1;COUNT2);
@Subset(TEXT1;COUNT2);
@Subset(TD1;COUNT2);
@Subset(FNLIST1;COUNT2);
@Subset(TEXTLIST1;COUNT2);
@Subset(TDLIST1;COUNT2);
@Subset(IDLIST1;COUNT2);
@Subset(IDLIST1;COUNT2;MODE3);
Description
Returns a sublist of FN/TEXT/TD/FNLIST/TEXTLIST/TDLIST/IDLIST FN1/TEXT1/TD1/FNLIST1/TEXTLIST1/TDLIST1/IDLIST1. If FN COUNT2 is positive, the first COUNT2 elements are returned; if COUNT2 is negative, the last COUNT2 elements are returned. If a range that no longer exists is accessed, a correspondingly shorter list is returned.
MODE3:
1=Convert to FLOATLIST if FN COUNT2<=8063 elements.
NOTE:
@Subset in APIEngine differs slightly from the Notes-@Function @Subset!
If COUNT2 has the value zero, the Engine returns a list with zero elements. Notes returns an error in this case.
Example: @Subset(FN1;COUNT2)
FN1:=10;
COUNT2:=1;
@Subset(FN1;COUNT2);
returns 10
Example: @Subset(TEXT1;COUNT2)
TEXT1:="Hallo Welt !!!";
COUNT2:=2;
@Subset(TEXT1;COUNT2);
returns "Hallo Welt !!!"
Example: @Subset(TD1;COUNT2)
TD1:=[30.09.93];
COUNT2:=-1;
@Subset(TD1;COUNT2);
returns [30.09.93]
Example: @Subset(FNLIST1;COUNT2)
FNLIST1:=10:11:12:13:14;
COUNT2:=4;
@Subset(FNLIST1;COUNT2);
returns 10:11:12:13
Example: @Subset(TEXTLST1;COUNT2)
TEXTLIST1:="New York":"Rio":"Tokio";
COUNT2:=-2;
@Subset(TEXTLIST1;COUNT2);
returns "Rio":"Tokio"
Example: @Subset(TDLIST1;COUNT2)
TDLIST1:=[29.09.93]:[30.09.93]:[01.10.93];
COUNT2:=2;
@Subset(TDLIST1;COUNT2);
returns [29.09.93]:[30.09.93]
Example: @Subset(IDLIST1;COUNT2)
IDLIST1:=@IDList:2000:1000:1004:3000:5000;
COUNT2:=-3;
returns the IDList for the last 3 elements of IDLIST1
Example: @Subset(IDLIST1;COUNT2;MODE3)
IDLIST1:=@IDList:2000:1000:1004:3000:5000;
COUNT2:=3;
MODE3:=1;
@Subset(IDLIST1;COUNT2;MODE3);
returns the FLOATLIST 2000:1000:1004
Note : This text was machine-translated and may contain inaccuracies.
