SelectItemsByPositions ( Items ; Positions )

Select Items from a comma delimited list by position specified as numbers in a comma delimited list

Be the first to rate this function Log in to vote

Binu Alexander - Show more from this author
ASC,
https://www.linkedin.com/in/drbinualexander/

Sample input:

SelectItemsByPosition( "Jack,Jill,Jane,Janardhan" ; 2,4 )

Sample output:

Jill,Janardhan

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let([
  i = Substitute(newFN; ","; "¶");
  p = Substitute(posManFN; ","; "¶");
  v1 = GetValue(i; GetAsNumber(GetValue(p; 1)));
  v2 = GetValue(i; GetAsNumber(GetValue(p; 2)));
  v3 = GetValue(i; GetAsNumber(GetValue(p; 3)));
  v4 = GetValue(i; GetAsNumber(GetValue(p; 4)));
  v5 = GetValue(i; GetAsNumber(GetValue(p; 5)));
  v6 = GetValue(i; GetAsNumber(GetValue(p; 6)));
  v7 = GetValue(i; GetAsNumber(GetValue(p; 7)));
  v8 = GetValue(i; GetAsNumber(GetValue(p; 8)));
  v9 = GetValue(i; GetAsNumber(GetValue(p; 9)));
  v10 = GetValue(i; GetAsNumber(GetValue(p; 10)));
  v11 = GetValue(i; GetAsNumber(GetValue(p; 11)));
  v12 = GetValue(i; GetAsNumber(GetValue(p; 12)));
  v13 = GetValue(i; GetAsNumber(GetValue(p; 13)));
  v14 = GetValue(i; GetAsNumber(GetValue(p; 14)));
  v15 = GetValue(i; GetAsNumber(GetValue(p; 15)));
  v16 = GetValue(i; GetAsNumber(GetValue(p; 16)));
  v17 = GetValue(i; GetAsNumber(GetValue(p; 17)));
  v18 = GetValue(i; GetAsNumber(GetValue(p; 18)));
  v19 = GetValue(i; GetAsNumber(GetValue(p; 19)));
  v20 = GetValue(i; GetAsNumber(GetValue(p; 20)))
];
  v1 & 
  If(not IsEmpty(v2); "," & v2; "") & 
  If(not IsEmpty(v3); "," & v3; "") & 
  If(not IsEmpty(v4); "," & v4; "") & 
  If(not IsEmpty(v5); "," & v5; "") &
  If(not IsEmpty(v6); "," & v6; "") & 
  If(not IsEmpty(v7); "," & v7; "") & 
  If(not IsEmpty(v8); "," & v8; "") & 
  If(not IsEmpty(v9); "," & v9; "") & 
  If(not IsEmpty(v10); "," & v10; "") &
  If(not IsEmpty(v11); "," & v11; "") & 
  If(not IsEmpty(v12); "," & v12; "") & 
  If(not IsEmpty(v13); "," & v13; "") & 
  If(not IsEmpty(v14); "," & v14; "") & 
  If(not IsEmpty(v15); "," & v15; "") &
  If(not IsEmpty(v16); "," & v16; "") & 
  If(not IsEmpty(v17); "," & v17; "") & 
  If(not IsEmpty(v18); "," & v18; "") & 
  If(not IsEmpty(v19); "," & v19; "") & 
  If(not IsEmpty(v20); "," & v20; "")
)

Select up-to 20 items from your item list ( comma delimited ) from the positions specified in the positions list ( comma delimited ). Handy if you have to often pick some items from a list just by position .

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

SelectItemsByPositions ( Items ; Positions )

Comments

Support this website.

Support this website.