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, periods,
or other 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.
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.