Shopping Cart

Free Newsletter
Signup

Contact

FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

FileMaker Pro Custom Functions

List | Show Random | Upload | Add This to Your Site

GetColumn ( text ; columnNumber ; columnDelimiter )

Rate this function:

Average rating: 4.4 (45 votes)
Discuss this Custom Function

Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net/

Returns a list of values from the requested column in text.

Sample Input:

GetColumn (
"1|2|3¶a|b|c¶x|y|z" ;
2 ;
"|"
)

Sample Output:

2
b
y

/* GetColumn function Author *COMMENT Visual Realisation Format GetColumn ( text ; columnNumber ; columnDelimiter ) Parameters text - any text expression or text field columnNumber - any numeric expression or field containing a number columnDelimiter - any text expression or text field Data type returned text Description Returns a carriage return-delimited list of values from the requested column in a tabular text array. July 7, 2008 */ Let ( [ row = GetValue ( text ; 1 ) ; cell = MiddleValues ( Substitute ( row ; columnDelimiter ; ¶ ) ; columnNumber ; 1 ) ; countRows = ValueCount ( text ) ] ; cell & Case ( countRows > 1 ; GetColumn ( RightValues ( text ; countRows - 1 ) ; columnNumber ; columnDelimiter ) ) )
Then copy & paste into FileMaker Advanced's Edit Custom Function window.

Description:

Returns a carriage return-delimited list of values from the requested column in a tabular text array.

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

This is my Custom Function and I want to edit it

Discuss:

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

Henry, Breda
February 07, 2016 7:53am

Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:

Download the Custom Function Dashboard Widget for OS X
Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

1.	ChiSquare3x2 ( param ; param ; param ; param )
	(Tue, Aug 14, 6:33am)
2.	ReverseByteOrder ( bytes )
	(Thu, Aug 09, 12:06pm)
3.	BytesToDec ( hex )
	(Thu, Aug 09, 11:47am)
4.	GetAsHexBytes ( number ; bytes )
	(Thu, Aug 09, 10:50am)
5.	ValCorrelationCoeff ( XValueList; YValueList; Xmean; Ymean; XStdDev; YStdDev )
	(Wed, Aug 08, 4:17pm)
6.	ValLeastSquaresSlope ( XValueList; YValueList; Xmean; Ymean )
	(Wed, Aug 08, 4:10pm)
7.	ValueMath ( List1 ; List2 ; operation )
	(Wed, Aug 08, 4:05pm)
8.	GetExtension ( File )
	(Tue, Aug 07, 10:22am)