Skip to main content

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:  

TextBetween 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.

Examples and results:  

Examples and results
Example Result
TextBetween('<abc>', '<', '>') Returns 'abc'
TextBetween('<abc><de>', '<', '>',2) Returns 'de'

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!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com