SplitLists18 ( CompoundList ; Delimiter )
Takes an array and moves rows to columns and columns to rows; breaks a typical EQSL result into columns
Be the first to rate this function Log in to vote
Bill Thurmes - Show more from this author
MDCA http://www.miyotadca.com |
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Splits a compound list into individual lists (any number of lists), transposing the array
Specifically, splits an array of columns (delimited by Delimiter) and rows (delimited by ¶) into rows and column, mapping columns to rows and rows to columns, so you can manipulate the resultant individual columns. You can then re-apply the CF to get back to your original (but manipulated) rows and columns.
Works with FMP 18 or later
This is *MUCH* faster than running an equivalent subroutine, but monopolizes the system while running. Often, a separate ESQL query for each column will be even faster.
Comments
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.