SUBSTRING1 Function
Description: Returns a string containing a portion of the source string. The substring begins at the specified start character and continues to the end of the string.
Parameters: String, Integer
- Source text: The string containing the source value.
- Start: The number of the starting character to be returned. The first character is number 1, the second character is number 2, etc.
Return: String containing the requested portion of the source text. If the source value is shorter than the requested start number, a null value will be returned.
Syntax: SUBSTRING1 (<source text>,<start>)
Example: Set the value in String 8 sub 1 to the value of String 8 from character 3 to the end of the value.
DE("String 8 sub 1").setValue
( SUBSTRING1( DE("String 8").getValue( ), 3 ) );
{{export-indexterm primary="SUBSTRING1 function"/}}
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*