GetColumn ( text ; columnNumber ; columnDelimiter )
Returns a list of values from the requested column in text.
Average rating: 4.3 (44 votes) Log in to vote
*COMMENT Visual Realisation
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Returns a carriage return-delimited list of values from the requested column in a tabular text array.
Feb 7, 2016
Ran into an issue with the 2008 version above, it caused Filemaker to use many GB's memory within 30 seconds and becoming unresponsive when getting columns from a (large) set of data. Found modified version which solved this entirely on the following page, from Mike_Mitchell
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.