String Functions
Prev
Next
Function Library Guide
Table of Contents
1 Function Library
+ 2 Control Flow Functions
+ 3 Console I/O Functions
+ 4 Type Conversion and Formatting
+ 5 Mathematics and Statistics
6 String Functions
+ 6.1 String Search and Extraction Functions
+ 6.2 Character Encoding and Decoding
+ 6.3 Miscellaneous String Functions
+ 7 Date and Time Functions
+ 8 Parameter Set Functions
+ 9 Table Functions
+ 10 Variables Functions
+ 11 Directory and File System Functions
+ 12 System Functions
+ 13 Help and Support Functions
+ 14 Cross-Functional Info
→ User Guide
→ Language Guide
Index
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