Brian Dunning's FileMaker Custom Functions

ITC_list__MatrixHoriz ( valueList ; columns )

Put the value of a list into a matrix of given columns number

  Average rating: 4.3 (27 votes) Log in to vote

SL   SL
ITC

Share on Facebook Share on Twitter

  Sample input:
ITC_list__MatrixHoriz ( "A¶A¶A¶B¶B¶B¶C¶C¶C¶ ; 3 )
  Sample output:
A A A
B B B
C C C

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

"ITC_list__MatrixHoriz" receives as parameters any kind of lists and replies with a matrix of the given columns number. The values are transposed too.
Requires the CF "ITC_list__MatrixHoriz_loop" which does the most of the work!
I found very useful these CF because I often need to represent a list in a matrix shape -"It'sa lot of space saved!"-, the values are transposed too.
I'm working now on a new CF: "ITC_list__Matrix", in this CF the values are not transposed but flow from a column to the next.

 

Comments

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.