Note: All text operators are case
sensitive.
Note: Text operators are not supported
for aggregated items.
Concatenate
appends the second
input string to the first input string.
For example,
Concatenate('A', 'B') returns
AB.
Contains
specifies that a matching
value must contain the specified string.
For example,
'Catcher'
Contains 'Cat' returns true.
EndsWith
specifies that a matching
value must contain the specified string at the end of the value.
For example,
'Catcher'
EndsWith 'her' returns true.
Format
applies a format to
the input value. Click the format field to select the format that
you want to apply. The output from the Format operator is a string.
For example, Format(1015.35, 'DOLLAR6.2') returns $1,015.35 as
a string value.
Note: Standard date formats in
SAS Visual Analytics display date and datetime values in the locale
of your browser. You can display date and datetime values in the locale
of the data source by using national language formats. The names of
national language formats begin with “NL.” For example,
the NLDATE format displays date values by using the locale of the
data source.
LowerCase
changes all of the
characters in a text string to lowercase.
For example,
LowerCase('SAS
INSTITUTE’) returns
sas institute.
NotContains
specifies that a matching
value must not contain the specified string.
For example,
'Catcher'
NotContains 'Dog' returns true.
Parse
interprets a numeric
or datetime value from the input string. Click the format field to
select the format that is used to interpret the string. The output
from the Parse operator is either a number or a datetime value, depending
on the format that you select.
For example,
Parse('15JAN2013', 'DATE9.') returns
15JAN2013 as a date value.
StartsWith
specifies that a matching
value must contain the specified string at the start of the value.
For example,
'Catcher'
StartsWith 'Cat' returns true.
UpCase
changes all of the
characters in the text string to uppercase.
For example,
UpCase('sas
institute') returns
SAS INSTITUTE.