c_AlternateValues ( theList ; oddOrEven )

Extracts the Odd or Even Values from a List

Average rating: 4.6 (24 votes) Log in to vote

Andrew Burt
None
http://www.google.com

Sample input:

c_AlternateValues ( "Olive Oil¶Diced Tomato¶Onion¶Lentils¶Chicken¶Cream" ; 1 )

Sample output:

Olive Oil
Onion
Chicken

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

/*

oddOrEven should be 1 for odd, 0 for even

*/

If ( oddOrEven ; 
  GetValue ( theList ; 1 ) & "¶" ; 
  ""
)
&
If ( ValueCount ( theList ) ≠ 0 ; 
  c_AlternateValues ( RightValues ( theList ; ValueCount ( theList ) -1 ) ; not oddOrEven )
  ; "" 
)

Used for splitting 1 list into 2 columns for displaying on a layout. Could be adapted to split into additional columns

Comments

		belg4mit Mar 15, 2023
In an effort to try to help others find this function, a common name for this sort of thing is 'unzip'; zip two lists together by alternating values from one then the other, and unzip is the reverse

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

c_AlternateValues ( theList ; oddOrEven )

Comments

Support this website.

Support this website.