All Articles

Trimr

The %TRIMR function is used to remove a string’s trailing blank spaces. Other than...

Triml

The %TRIML method is used to remove a string’s leading blank spaces. Other than...

Trim

To remove blank space from a string on both sides, use the %TRIM function....

Timestamp

To convert a string into a timestamp data type, use the %TIMESTAMP method. Syntax:...

Subst

The string is partially extracted from any point using the %SUBST method. The source...

Subdt

A subset of the data in a date, time, or timestamp value is extracted...

Status

The program or file status’s most recent value is returned by the %STATUS function....

Sqrt

%SQRT returns the square root of the specified numeric expression. If the operand is...

Split

%SPLIT splits a string into an array of substrings. It returns a temporary array...