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
    vlength
    width
    height
    text row

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

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

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

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

trim [string function]:
    trim
    trim all
    vtrim
    vtrim 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
    characters

replicate strings:
    replicate
    replicate characters

pad strings, align strings:
    align
    align right
    pad
    pad right
    random letters
    random string
    describe
    abbreviate name