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
    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