FirstWords_from_List ( _List )

get every first word from a value list

Average rating: 4.8 (14 votes) Log in to vote

Thomas Siebert - Show more from this author
http://www.t-seabird.de

Sample input:

1 Washington
2 Berlin
3 Moscow
arf Pumpkin

Sample output:

1
2
3
arf

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

/*
FirstWords_from_List ( _List )

version 5
---------------------------------------------
Thomas Siebert, 22.04.2016
info@t-seabird.de
www.t-seabird.de
---------------------------------------------

get every first word from a value list:

Input:
1 Washington
2 Berlin
3 Moscow
arf Pumpkin

Output:
1
2
3
arf

*/

Let ([
Value_Count = ValueCount ( _List ) - 1 ; 
First_Word = LeftWords ( GetValue ( _List ; 1 ) ; 1 ) ;
ValuesNotProcessed = RightValues ( _List ; Value_Count )
];


List ( 
	First_Word ;
 	Case ( Value_Count > 0 ; FirstWords_from_List ( ValuesNotProcessed ) ) ;
)

)

get every first word from a value list:

Input:
1 Washington
2 Berlin
3 Moscow
arf Pumpkin

Output:
1
2
3
arf

Comments

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

FirstWords_from_List ( _List )

Comments

Support this website.

Support this website.