Brian Dunning's FileMaker Custom Functions

ITC_list__MatrixHoriz_loop ( valueList ; countOfValues ; columns ; sepArray )

Part of the CF

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

SL   SL
ITC

Share on Facebook Share on Twitter

  Sample input:
ITC_list__MatrixHoriz_loop ("A¶A¶A¶B¶B¶B¶C¶C¶C¶";6;3; "2¶4¶6¶8¶10¶12¶14¶16¶18¶"; 0)
  Sample output:
A A A
B B B
C C C

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

After you have passed it a list through "ITC_list__MatrixHoriz", "ITC_list__MatrixHoriz_loop" replies with a matrix of the given columns number.
The separators are TABs between the columns and RETURNs between the rows. The values are transposed!
Don't worry about the number of parameters!
This CF depends on "ITC_list__MatrixHoriz ( valueList ; columns )" that needs only two parameters: the value list and the desidered number of columns.

 

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.