CombineValues ( list1, list2, divider )

returns a grid of all values in two lists

Average rating: 4.4 (29 votes) Log in to vote

Jeff Drake - Show more from this author
Drakeling Technologies

Sample input:

CombineValues( "1¶2¶3"; "4¶5¶6"; "|" )

Sample output:

1|4
1|5
1|6
2|4
2|5
2|6
3|4
3|5
3|6

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

Let([$ƒCounter[1] = Case($ƒCounter[1]; $ƒCounter[1]; 1);
       $ƒCounter[2] = Case($ƒCounter[2]; $ƒCounter[2]; 1)
]; //end define Let

   Substitute( MiddleValues( list1; $ƒCounter[1]; 1 ); ¶; "" ) & divider &
   Substitute( MiddleValues( list2; $ƒCounter[2]; 1 ); ¶; "" ) &

   Case(

      $ƒCounter[2] < ValueCount(list2);
         Let( $ƒCounter[2] = $ƒCounter[2] + 1; ¶ & CombineValues(list1; list2; divider) );

      $ƒCounter[1] < ValueCount(list1);
         Let([$ƒCounter[1] = $ƒCounter[1] + 1; $ƒCounter[2] = 1]; ¶ & CombineValues(list1; list2; divider) );

      Let([$ƒCounter[1] = ""; $ƒCounter[2] = ""]; "") //clear variables when done

   ) //end Case

) //end Let

(This function is to be used with the CombineValuesExecute funcion.)

Given two return-separated value lists x and y, this function will return all combinations of values in the matrix [x|y].

[x1|y1], [x1|y2], … [x1|yn],
[x2|y1], [x2|y2], … [x2|yn],
…
[xm|y1], [xm|y2], … [xm|yn].

Edited to replace compound function with self-contained version.

Comments

		deliotoledo May 24, 2024
Thanks!

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

CombineValues ( list1, list2, divider )

Comments

Support this website.

Support this website.