Function EN Version 1.90

@Subset

Float IDList List Misc NUMBER Text TimeDate

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.