ITC_list__MatrixHoriz_loop ( valueList ; countOfValues ; columns ; sepArray )

Part of the CF

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

SL - Show more from this author
ITC

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)

Let ( [ tab = "	" ; counter = counter + 1 ; test = Mod ( counter ; columns ) = 0  ; p = MiddleValues (sepArray ; counter ; 1 ) ; result = Case ( test and counter ≠ 0 ; valueList ; Replace ( valuelist ; p ; 1 ; tab ) ) ] ;  If ( counter = countOfValues ; result ; ITC_list__MatrixHoriz_loop ( result ; countOfValues ; columns ; sepArray ; counter ) ) )

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

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

ITC_list__MatrixHoriz_loop ( valueList ; countOfValues ; columns ; sepArray )

Comments

Support this website.

Support this website.