String Formatting

Command

Description

Fmt()

Formats text according to length and justification specified, and/or any masks.

Format()

Applies a specified format to data. In addition, Format can return converted data rows. The return value is the formatted row. If errors are encountered in formatting or converting data, an error and a null row are returned instead.

IConv()

Converts from display format to internal format. Formats supported are: Boolean, date, datetime, decimal numbers, time, hex, scientific notation, and binary.

OConv()

Converts from internal format to display format. Formats supported are the same as IConv. Fmt and OConv can be used interchangeably.

Quote()

Puts a specified string into double quotes.

Space()

Generates a string of spaces.

Str()

Creates a string of repeating characters.

Trim(),TrimB(), TrimF()

Deletes extra (more than one together) spaces in a string. TrimF and TrimB trim forward and back trailing spaces, respectively.