QlikWorld 2020 Global Conference. Join us to discover how to get the most from your data. Act fast. Register now and save.

TextBetween - script and chart function

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


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

Return data type: string


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.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?