Table of Contents
Next
Function Library
Table of Contents
Function Library
- Control Flow Functions
- Branches
if, unless
else
once
switch, check
case
break, continue
break loop, continue loop
break case, continue case
continue with next case
- Loops
repeat
do
for
while, until
for all
for all variables
for all characters
- User-Defined Procedures and Functions
define procedure / function
define additional procedure / function
Parameter Types in User-Defined Functions
return
function / user function existing
delete user function
- Launch other B4P programs
start
include
get long options
- Exception Functions
pause
stop
interactive
exit
end
abort
throw
catch, catch if
exception
null
- Comparison and Selection Functions
select, pick
select if, pick if
select ifs, pick ifs
select/pick if existing ...
select / pick by value
compare select / pick
replace if
- Code Execution Functions
call
deep, deepr
exec
calc
compare
assign
table assign
- Console I/O Functions
- Text Input / Output
echo, print ...
print bar
format, format print
compose ...
input
input to complete
input quick ...
getch ...
clipboard
- Console Special Effects
cls
clear
cursor
- text / background color
List of Text and Background Colors
console
blinking
boldface
reverse
underscore
reset console
- Inspection and Debugging
prompt
see
inspect
list variables ...
- Type Conversion and Formatting
- str, soft
String to String Formatting
Void to String Formatting
Numeral to String Formatting
Date to String Formatting
Set to String Formatting
Boolean to String Formatting
Smart Formatting
num
clean num, clean if num
smart num, smart if num
date, pure date, date time
time, pure time
Date and Time Detection Rules
bool
set
best type
join ...
type, subtype
hash signature
excel column
excel coordinates
excel validate sheet name
- Mathematics and Statistics
- Basic Math Functions
is numeric / integer - Functions
even, odd, whole
zebra
abs - Absolute Value
round, round up / down
mod - Modulo function
random - Random Integers
hex to decimal
distribute amount
- Transcendental Functions
sqrt, cbrt - Square and Cube Roots
pow - Power Function
Exponential Functions
Logarithmic Functions
Trigonometric Functions
Hyperbolic Functions
- Series Functions
Arithmetic and Boolean Series Functions
min, max Functions
vmin ..., vmax ...
min, max Functions on Strings
min, max Functions on Numerals
limit
count Functions
- Matrix Functions
identity
mmul, mmdiv - Multiplication and Division
minv - Matrix Inversion
mdet - Matrix Determinant
linear - Solve Linear Equations
horizontal
vertical
flat
diagonal
transpose
flip horizontally / vertically
rotate left / right
print / compose matrix
- Statistics Functions
Basic Statistics Functions
quantile ...
covariance, correlation
gini Coefficient Functions
Linear and Exponential Regression
- Interpolation Functions
Interpolation Examples Visualized
histogram
Conditional Combination Functions
- Finance and Business Functions
cagr - Compond Annual Growth Rate
irr - Internal Rate of Return
tv - Terminal Value
discount - Discount Values
distribute - Value Distribution over Timeline
- String Functions
- String Search and Extraction Functions
find ... (string function)
replace, replace all
substitute, substitute all
length ... (string function)
width
height
text row
left ... (string function)
right ... (string function)
middle ... (string function)
outside ... (string function)
trim ... (string function)
clean
tokenize
get differences
locate differences
- Character Encoding and Decoding
chr
code
decode entities
encode entities
- Miscellaneous String Functions
characters
replicate ... (string function)
pad, align ...
random string, random letters
describe
abbreviate name
- Date and Time Functions
- Date Functions
date inside, time inside
year, quarter, month, day
day of year
serial date
weekday
week
fq - Fiscal Quarter
fy - Fiscal Year
reschedule
- Time and Stopwatch Functions
hour, minute, second
Stopwatch Functions
- Sleep and Wait Functions
sleep, sleep countdown
sleep until, sleep until countdown
wait until, wait until countdown
wait, wait countdown
- Set Functions
- Set Search and Extraction Functions
length ... (set function)
find ... (set function)
left ... (set function)
right ... (set function)
middle ... (set function)
outside ... (set function)
trim ... (set function)
count elements ...
subset ...
filter ...
- Table Functions
- Loading and Saving Tables
- table load ...
Loading HTML files
Loading FULL HTML files
Loading XML files
Loading JSON files
- table save ...
Saving JSON files
excel list sheets
table load excel file
table save excel file
- Console I/O with Tables
table list
table menu, table menu quick
- Creating, Writing, Reading, Deleting
- Creating and Building up Tables
table create ...
table initialize
table configure
forget memorized table columns
- Writing Tables
table append ...
table append blank rows
table add row, table write row
table (write or) add missing row
table write column selected rows
table write cells ...
- Reading Tables
table read row
table read column selected rows
table read cells ...
- Deleting Tables
table clear ...
table delete ...
- Accessing Table Information
list tables
table existing
table length
table row width
table min/max width
row
col
- 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
table explore
table filter ...
table extract ...
- Control Flow Functions for Tables
with table
for all table rows
for all table selected rows
for all table columns
for all table selected columns
for all current table columns
for all current table selected columns
- Processing Tables
- Checking and Processing Headers
table check header
table column number
table check headers ...
table rename ... headers
table correct headers ...
table lift ...
- Processing Table Columns
table insert (missing) columns
table add/insert calculated columns
table copy columns ...
table duplicate columns
table sort columns
table rearrange ... columns
table keep ... columns
table delete columns
table delete remaining columns
table delete blank/empty/unnamed columns
- Processing Table Rows
table insert rows (if needed)
table insert ... selected rows
table delete rows (if needed)
table delete remaining rows (if needed)
table delete selected rows
table keep selected rows
table delete blank rows
table check row
table move rows
table move selected rows
table rearrange selected rows
table sort (selected) rows
table rank (selected) rows
- Processing Table Contents
table process (all) (selected rows)
table process selected rows fast
table process (selected) columns
table process cells (selected rows)
- table process cells (selected rows) in columns
Addt'l Info on fast rows processing
table manipulate (selected rows)
table fill vertically ...
table fill horizontally ...
table substitute vertically ...
table substitute horizontally ...
table insert cells selected rows
table insert cells in columns
table delete cells selected rows
table delete cells in columns
table flip horizontally / vertically
table rotate left / right
table format numbers
table clean
table fit
- Pivoting and Conosolidating Tables
table flip columns
table flip rows
table flip selected rows
table transpose
table serialize ...
table spread ...
table spread given headers ...
table consolidate ...
table distribute ...
table histogram
- Copying, Renaming and Splitting Tables
table rename
table copy table
table copy/split table selected rows
table copy table columns ...
table split table columns ...
- Multi-Table Integration
- Comparing and Validating Tables
- table compare ...
Table Comparison Strategy
Table Comparison Reports
Change Indication Function
- table validate
table validate - Row and Group Results
table validate - Examples
table check duplicates ...
- Looking up Other Tables
table lookup ...
table lookup once ...
table lookup fast ...
table lookup smart ...
table lookup smart once ...
table lookup with rules ...
table lookup with rules once ...
table integrate ...
table integrate once ...
table integrate fast ...
table integrate smart ...
table integrate smart once ...
table integrate with rules ...
table integrate with rules once ...
table expand ...
table expand fast ...
table expand smart ...
table expand fast smart ...
table expand with rules ...
table expand with rules once ...
table expand fast with rules ...
table expand fast with rules once ...
table digest ...
table digest smart ...
table digest with rules ...
table digest with rules once ...
Table Integration Operation Identifiers
table describe ...
- Combining Multiple Tables
table merge ...
table overlay/subtract ...
table intersect ...
table subtract ...
table exclude ...
table multiply ...
table divide ...
table arrange ...
- Formatting and Styling Tables
- Defining User Specific Colors
Color Palettes
add color
rgb
darken color
lighten color
weaken color
lighten colors
darken colors
weaken colors
- Styling Functions
table style table
table style rows
table style columns
table style cells
Generic Formatting Attributes
Formatting Coverages and Precedences
table style auto width
table style themes (beta)
- Finishing up formatting
translate style attributes ...
table style reset
- Variables Functions
- Basic Variables Functions
existing (here and valid)
copy
identify
scope
name
exchange
protect ...
delete
delete members
insert members (protect)
global
local
regional
- Arrays and Structures
dim / redim
dim / redim protect
array, array protect
structure, structure protect
member count
weight, weight profile
depth
structure to array ...
array to structure ...
variable members, variable names
- Loading and Saving Variables
variable load ...
json to variable ...
variable save ...
variable to json ...
- Variable References Functions
release
release all
- Resident Attributes Functions
attribute ...
- Directory and File System Functions
- Basic Directory and File Functions
directory existing, file existing
read access ..., write access ...
working directory
pwd working directory command
change directory commands
starting directory
directory size
file size
disk space ...
- Listing and Searching Directories and Files
directory listing ...
advanced directory listing ...
file browser
dir
search files ...
choose recent file
count files ...
resolve path/directory/file name
office document properties
- Manipulating Directories and Files
directory create ...
create directory commands
directory create temp
file delete ...
file delete multiple/recursive ...
directory delete ...
directory delete multiple/recursive ...
remove directory commands
file rename ...
directory rename ...
file copy ...
file copy mulitple/recursive ...
file create link ...
file download ...
- File Compression and Decompression
zip compress
zip extract files
zip extract all
- System Functions
- Executing System Commands
open
system
quote path
set locale
Registry Access Functions
- Licensing and Privileges
global / script privileges
license provide identification
license apply key
- Help and Support Functions
help
help ...
docs
openweb
docs search
browser
table view
variable view
view
view reset
list / explain functions
dump functions
dump entities
- Cross-Functional Info
Sorting and Ranking Options
Consolidation Actions
User Guide
Language Guide
Table Processing
Index
Table of Contents
See the navigator bar for full table of contents.