Text (Simple) Operators

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.