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
Michael Horak - Show more from this author
*COMMENT Visual Realisation |
"1|2|3¶a|b|c¶x|y|z" ;
2 ;
"|"
)
b
y
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.
Comments
Henry, Breda 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 https://community.filemaker.com/message/171033#171033 |
||
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.