String intrinsic functions
Ancestors - None
Container for all common string intrinsic functions
Name | Description |
---|---|
AsDbcsFixedChar | Return the string as a Fixed length DBCS string
Result, TargetLength |
AsDbcsString | Return the string as a DBCS string
Result |
AsSbcsString | Return the variable as a single byte character string
Result |
BlankConcat | Concatenate strings with a blank between each
Result, String1, String2, String3, String4, String5, String6, String7, String8, String9 |
ByteTypeAt | Return the byte type at a specific position in the string
Result, Index |
Center | Center the string within the variable
Result, Length, Pad, LengthType |
Centre | Centre the string within the variable
Result, Length, Pad, LengthType |
CharTypeAt | Return the character type at a specific position in the string
Result, Position |
Compare | Compare two strings
Result, To, CompareKind, IgnoreCase |
Concat | Concatenate strings ignoring trailing spaces
Result, String1, String2, String3, String4, String5, String6, String7, String8, String9 |
Contains | Test to see is a string is contained in the variable
Result, String, StartPosition |
ContainsOnly | Test to see if the strings contains only the specified characters
Result, String |
CurChars | The number of characters in the string
Result |
CurEbcdicSize | Length of the string in EBCDIC
Result |
CurSize | Length of the variable content in bytes
Result |
Decrypt | Decrypt the string using the TEA algorithm
Result, Key |
DeleteSubstring | Delete part of a string
Result, StartPosition, Length |
Encrypt | Encrypt the string using the TEA algorithm
Result, Key |
InsertString | Insert a string in a string
Result, String, At, Pad |
IsDbcs | Test if the string is DBCS
Result |
IsMatch | Does the string match the regular expression
Result, Pattern |
IsMixed | Test if the string contains SBCS and DBCS characters
Result |
IsNotSqlNull | Test if the variable is not SQLNull
Result |
IsSbcs | Test if the string is DBCS
Result |
IsSqlNull | Test if the variable is SQLNull
Result |
IsValidEmail | Test whether the string contains a valid email address
Result |
IsValidPassword | Test whether the string contains a valid password
Result, Strength |
LastPositionIn | Find the last position of the subject in a string
Result, String |
LastPositionOf | Find the last position of the value in this variable
Result, String |
LeftMost | Get the left most characters from the string
Result, Characters, Pad |
LeftTrim | Trim characters from the left of the string
Result, OfText |
LowerCase | Convert a string to lower case
Result |
OccurrencesIn | Find the number times the string occurs in a variable
Result, String, StartPosition |
OccurrencesOf | Find the number times the variable occurs in the string
Result, String, StartPosition |
PositionIn | Find the position of this variable in a string
Result, String, StartPosition |
PositionOf | Find the position of a string in this variable
Result, String, StartPosition |
Remove | Remove the specified string from the source
Result, Object |
RemoveAll | Remove all occurrences of the specified string from the source
Result, Object |
RemoveCharacters | Remove all occurrences of the specified characters from the source
Result, Object |
Repeat | Repeat a string a number of times
Result, Times |
Replace | Replace the specified string
Result, Object, Replacement |
ReplaceAll | Replace all occurrences of the specified string in the source
Result, Object, Replacement |
ReplaceSubstring | Replace a portion of a string with a new value
Result, StartPosition, Length, With, Pad |
Reverse | Reverse a string
Result |
RightAdjust | Right adjust the string
Result, Length, Pad |
RightMost | Get the right most characters from the string
Result, Characters, Pad |
RightTrim | Trim characters from the right of the string
Result, OfText |
Substitute | Embed strings at specific substitution points (&1 &2 etc)
Result, String1, String2, String3, String4, String5, String6, String7, String8, String9 |
Substring | Return part of a string
Result, StartPosition, Length, Pad |
TranslateCharacters | Translate the specified characters
Result, From, To |
Trim | Trim characters from either end of the string
Result, OfText |
TrimBlankConcat | Concatenate with blanks trimming trailing blanks
Result, String1, String2, String3, String4, String5, String6, String7, String8, String9 |
TrimConcat | Concatenate trimming trailing blanks
Result, String1, String2, String3, String4, String5, String6, String7, String8, String9 |
TrimSubstitute | Embed strings at specific substitution points (&1 &2 etc) trimming trailing blanks
Result, String1, String2, String3, String4, String5, String6, String7, String8, String9 |
UpperCase | Convert to upper case
Result |
UrlDecode | Convert an encoded URL to text
Result |
UrlEncode | Convert a URL to encoded text
Result |
Febuary 18 V14SP2