Search and Replace Functions
Prev
Next
Function Library
Table of Contents
Function Library
+ Control Flow Functions
+ Console I/O Functions
+ Type Conversion and Formatting
+ Mathematics and Statistics
+ String Functions
+ Date and Time Functions
+ Set Functions
- Table Functions
+ Loading and Saving Tables
+ Console I/O with Tables
+ Creating, Writing, Reading, Deleting
+ Accessing Table Information
- Searching and Exploring Tables
- Search and Replace Functions
table search, table search vertically
table search row
table find row
table selected rows
table selected columns/headers ...
table search header row
table find cells ...
table replace cells ...
+ Explore, Filter, Extract Sub-Tables
+ Control Flow Functions for Tables
+ Processing Tables
+ Multi-Table Integration
+ Formatting and Styling Tables
+ Variables Functions
+ Directory and File System Functions
+ System Functions
+ Help and Support Functions
+ Cross-Functional Info
User Guide
Language Guide
Table Processing
Index
Introduction
This section summarizes the basic fuctions which include the following:
Search entire table for specific values
Search rows
Identify all rows with selection criteria met
Identify all columns or headers with selection criteria met
Search the header row
Procedures and Functions Provided:
Searching tables:
table search
table search vertically
table search row
table find row
table all selected rows
table selected rows
table selected column numbers
table selected columns
table selected headers
table search header row
table find cells
table find cells in columns
table find cells selected rows in columns
table find cells seleted rows
table replace cells
table replace cells in columns
table replace cells selected rows in columns
table replace cells seleted rows