Text_Get_DelimitedValue ( _text ; _delimiter ; _occurence ; _default )

Extracts the nth value from a delimited text counting from the left or right end.

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

Rewolfer - Show more from this author
http://rewolfer.de

Sample input:

Text_Get_DelimitedValue ("this|table|broke|down"; "|"; -2; "not found")

Sample output:

broke

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*=========================================

FORM:		Text_Get_DelimitedValue ( _text; _delimiter ; _occurence ; _default )

PURPOSE:	extracts the nth value from a delimited text counting from the left or right end

PARAMETER:	_text		text		not ""		text
		_delimiter	text		not ""		delimiters like "|" or "<br />" etc
		_occurrence	number		not 0		nth occurrence that is wanted; negative value counts from right
		_default		text		""		default value to be returned if delimiter was not found or occurence was out of index

RESULT:		text (or default-parameter)

DEPENDENCY:	-

NOTE:		supports only ONE delimiter

EXAMPLE:	Text_Get_DelimitedValue ("this|table|broke|down"; "|"; -2; "not found") --» "broke"

HISTORY:	2006-03-03 [155209]	2.00	tsw	function checks now if LINE starts and ENDS with delimiter and appends it if necessary
		2007-02-15 [231014]	3.00	tsw	function can now count occurrences from left or right (eg: usefull to get LAST OCCURRENCE)
		2008-03-14 [115706]	3.01	tsw	changed variable SEPARATOR to DELIMITER
		2011-03-12 [112221]	3.02	tsw	renamed to current convention
		2011-03-15 [191752]	3.03	tsw	renamed again
		2011-04-14 [100354]	3.50	tsw	fixed multi-char-delimiters; introduced error-parameter; updated documentation; renamed function again
		2012-04-10 [000613] 	3.51 	tsw 	renamed parameters and imported into Tool12
		2012-04-27 [095021] 	4.00 	tsw 	revamped with value lists (omitted _direction)
		2012-05-01 [093039] 	4.01 	tsw 	checked for out of index

DEVELOPER:	tsw @ http://rewolfer.de
		
=========================================*/

Let (
   [
   _vl = Substitute ( _text ; _delimiter ; ¶ );
   _vlCount = ValueCount ( _vl );
   // occurrence from right end of text
   _occurrence = Case ( _occurrence < 0 ; _vlCount + _occurrence + 1 ; _occurrence )
   ];

   Case ( _occurrence and _vlCount >= Abs ( _occurrence );
	GetValue ( _vl ; _occurrence ) ;
	_default
   )
)

/*=========================================

FORM: Text_Get_DelimitedValue ( _text; _delimiter ; _occurence ; _default )

PURPOSE: extracts the nth value from a delimited text counting from the left or right end

PARAMETER: _text text not "" text
_delimiter text not "" delimiters like "|" or "
" etc
_occurrence number not 0 nth occurrence that is wanted; negative value counts from right
_default text "" default value to be returned if delimiter was not found or occurence was out of index

RESULT: text (or default-parameter)

DEPENDENCY: -

NOTE: supports only ONE delimiter

EXAMPLE: Text_Get_DelimitedValue ("this|table|broke|down"; "|"; -2; "not found") --» "broke"

DEVELOPER: tsw @ http://rewolfer.de

=========================================*/

Comments

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

Text_Get_DelimitedValue ( _text ; _delimiter ; _occurence ; _default )

Comments

Support this website.

Support this website.