Searching and Exploring Tables
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
+ 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 subsection contains various search and exploration functions.
Search functions across rows, columns and the entire table using different comparing methods
Exploration: explore - filter - extract sub-tables
Table widths in specific rows and overall table widths
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
Explore, filter and extract tables:
table explore
table filter
table filter ignore case
table extract