TextBetween - script and chart function

TextBetween() returns the text in the input string that occurs between the characters specified as delimiters.

Syntax:

TextBetween(text, delimiter1, delimiter2[, n])

Return data type: string

Arguments:

Argument	Description
text	The original string.
delimiter1	Specifies the first delimiting character (or string) to search for in text.
delimiter2	Specifies the second delimiting character (or string) to search for in text.
n	Defines which occurrence of the delimiter pair to search between. For example, a value of 2 returns the characters between the second occurrence of delimiter1 and the second occurrence of delimiter2.

Example	Result
TextBetween('<abc>', '<', '>')	Returns 'abc'
TextBetween('<abc><de>', '<', '>',2)	Returns 'de'
TextBetween('abc', '<', '>') TextBetween('<a<b', '<', '>')	Both examples return NULL. If any of the delimiter is not found in the string, NULL is returned.
TextBetween('<>', '<', '>')	Returns a zero-length string.
TextBetween('<abc>', '<', '>', 2)	Returns NULL, as n is greater than the number of occurrences of the delimiters.

Load *,
textbetween(Text,'<','>') as TextBetween,
textbetween(Text,'<','>',2) as SecondTextBetween;
Load * inline [
Text
<abc><de>
<def><ghi><jkl> ];

Result

Text	TextBetween	SecondTextBetween
<abc><de>	abc	de
<def><ghi><jkl>	def	ghi

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!