String Functions

Prev Next

Introduction

This section describes procedures and functions for character and string manipulations.


Procedures and Functions Provided:


find [string function]:
    find
    find ignore blanks
    find ignore both
    find ignore case
    replace
    replace all
    substitute
    substitute all

length [string function]:
    length
    width
    height
    text row

left [string function]:
    left
    left include
    left last match
    left last match include

right [string function]:
    right
    right include
    right last match
    right last match include

middle [string function]:
    middle
    middle include
    middle until
    middle until include

outside [string function]:
    outside
    outside exclude
    outside until
    outside until exclude

trim [string function]:
    trim
    trim all

clean up exotic spaces and line breaks in strings:
    clean
    tokenize
    get differences
    locate differences

character encoding:
    chr

character decoding:
    code
    decode entities
    encode entities

replicate strings:
    replicate
    replicate characters
    random letters
    random string
    describe
    abbreviate name