Scripting - QlikView 11 for Developers - page 238

Function Explanation Example Result

keepchar(string,
characters to
keep)

Returns the string
without the
characters that are
not specified in the
keep list.

keepchar('QlikView',
'ike')

ikie

purgechar
(string,
characters to
purge)

Returns the string
minus the characters
specified in the
purge list.

purgechar
('QlikView', 'ie')

QlkVw

textbetween Returns the substring

found between the
start and end text.
If an occurrence is
specified QlikView
will look for that
specific occurrence,
otherwise the first
occurrence will be
assumed.

textbetween
('<Qlik><View>',
'<', '>')
textbetween
('<Qlik><View>',
'<', '>', 2)

Qlik

View

(string, start
text, end text,
occurrence
(optional))

trim(string) Returns the string

without any leading
and trailing spaces.

trim(' QlikView ') QlikView

ltrim(string) ltrim(' QlikView

')

Same as the trim
function, but only
removes leading
spaces.

QlikView

rtrim(string) Same as the trim

function, but only
removes trailing
spaces.

rtrim(' QlikView
')

QlikView

Information on other string functions can be found by selecting Help | Help from
the menu, choosing the Index tab, and searching for String functions .

Of course, all of these functions can be nested. For example, in our Airline
Operations document, origin and destination airports follow the following
naming convention:

[Name of town], [State or Country]: [Name of Airport]

For example:

New York, NY: John F. Kennedy International