The following commands allow you to control string processing within a logic routine.  In-Line Substringing is a facility that may be used independently or in conjunction with logic commands to manipulate data.

These logic commands support strings of up to 2,000 bytes in length.


Logic Command

Description
 

IN-ALPHA

Tests if one string is within another string, on a byte-by byte basis.
 

INDEX

Returns the start position of one string within another string in bytes.
 

LEN

Determines the length of a string in bytes.
 

IN-ALPHA-NLS

Tests if one string is within another string by characters.
 

INDEX_NLS

Returns the start position of one string within another string in characters.
 

LEN-NLS

Determines the length of a string in characters.
 

LEN-SCREEN

Returns the length on the screen for a multiple-byte string.
 

UPPER_CASE

Converts a string into uppercase.
 

LOWER_CASE

Converts a string into lowercase.
 

MIXED_CASE

Converts to Mixed Case (First letter capitalised and the rest changed to lower case).
 

STRCOMP

Compares two strings in either case sensitive or insensitive mode.
 

TRIM

Removes specified characters from a string.
 

TRIML

Removes leading spaces from a string.
 

TRIMR

Removes trailing spaces from a string.
 

CHANGE

Replaces all occurrences of a sub-string within the source string with the replacement sub-string.
 

TOKEN
 

Can be used iteratively to return the string delimited by a list of delimiters.
 

SQUOTE

Envelops a string with single quote characters.
 

DQUOTE

Envelops a string with double quote characters.
 

XQUOTE

Envelops a string with a specified character or the first character in the specified string.
 

 

Comment on this topic

Topic ID: 520152