Note: All text operators are case
sensitive.
Note: Text operators are not supported
for aggregated items.
FindChar
finds the position of a
character or any of a set of characters within a
text string. The position of the first match is returned as a
numeric value. If no matches are found, then 0 is returned. The first
input string specifies the value to search within. The second input
string specifies the list of characters to search for.
For example, FindChar('mystring', 'sz')
returns
3.
FindString
finds the position of a string within another string. The position of the first match
is returned as a numeric value. If no matches are found, then 0 is returned. The
first input string specifies the value to search within. The second input string specifies
the string
to search for.
For example, FindString('mystring', 'st')
returns
3.
GetLength
returns the length of an input string as a numeric value.
For example, GetLength('mystring')
returns
8.
GetWord
returns a word from an input string where the words are separated by spaces, periods,
or other
special characters. The first
parameter specifies the input string. The second parameter specifies the number of the word
to return where 1 is the first
word.
For example, GetWord('my
test string', 2)
returns test
.
RemoveBlanks
removes space characters from the input string. The first parameter specifies the
input string. The second parameter specifies which space characters to remove. Select
one of the
following:
_All_
removes all spaces from the string.
_Leading_
removes spaces at the beginning of the string.
_LeadingAndTrailing_
removes spaces at the beginning and end of the string.
_Trailing_
removes spaces at the end of the string.
For example, RemoveBlanks('my
test string', '_ALL_')
returns myteststring
.
RemoveChars
removes all instances of a set of characters from the input string. The first parameter
specifies the input string. The second parameter specifies the list of characters
to remove.
For example, RemoveChars('my_test_string', '_')
returns myteststring
.
RemoveWord
removes a word from an input string where the words are separated by spaces or special
characters. The first parameter specifies the input string. The second parameter specifies
the number of the word to remove where 1 is the first
word.
For example, RemoveWord('my
test string', 2)
returns my string
.
Note: In addition to spaces, the
following characters are used as delimiters in the input string: .
< ( ) + & ! $ * ; ^ - / , % | ’
Replace
replaces a
substring within the input string with a replacement string. The first parameter specifies
the input string. The second parameter specifies the substring to replace.
The third parameter specifies the replacement string. The fourth parameter specifies
which instances of the substring to replace. Select one of the following:
_FIRST_
replaces the first
instance only.
_LAST_
replaces the last instance
only.
For example, Replace('my
test string test', 'test', 'new', '_ALL_')
returns my
new string new
.
ReplaceWord
replaces a word from an input string where the words are separated by spaces, periods,
or other special characters. The first parameter specifies the input string. The second
parameter specifies the number of the word to replace where 1 is the
first word. The third parameter specifies the replacement string.
For example, ReplaceWord('my
test string', 2, 'new')
returns my
new string
.
Reverse
reverses the order of the characters in the input string.
For example, Reverse('A
B C')
returns C B A
.
Substring
returns a substring from the input string based on the position of the characters.
The first parameter specifies the input string. The second parameter specifies the
position of the first character to return. The third parameter specifies the number
of characters to return.
For example, Substring('my
test string', 4, 3)
returns tes
.
Update
replaces a substring from the input string based on the position of the characters.
The first parameter specifies the input string. The second parameter specifies the
position of the first character to replace. The third parameter specifies the number
of characters to replace. The
fourth parameter specifies the replacement string.
For example, Update('my
test string', 4, 3, 'nex')
returns my
next string
.
URLDecode
removes URL
encoding from the input string. URL encoding replaces some characters with a % character followed
by a two-digit hexadecimal code.
For example, URLDecode('support.sas.com%2Fmy%20string')
returns support.sas.com/my
string
.
URLEncode
applies URL encoding to the input string. URL encoding replaces some characters with
a % character followed by a two-digit hexadecimal code.
For example, URLEncode('support.sas.com/my
string')
returns support.sas.com%2Fmy%20string
.