String Search and Extraction Functions

Prev Next

Introduction

This subsection describes various functions to search for string patterns and extract substrings from stings.


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