Introduction
A set of functions are available to convert data in one type (e.g. strings) into other types (e.g. dates and numerals).
Converting values to string type supports a broad library of smart formatting features in order to output numbers, dates, etc.
in a desirable format.
Procedures and Functions Provided:
string conversion, formatting template, string conversion functions:
soft
str
vsoft
vstr
numeral conversion function:
num
clean numerals:
clean if num
clean num
smart numerals:
smart if num
smart num
date conversion functions:
date
date time
pure date
time conversion functions:
pure time
time
boolean conversion function:
bool
set [function name]:
set
Identify optimum data type for value provided:
best type
Join set elements into a string:
join
join ignore blanks
join unique
join unique ignore blanks
Identify variable types and subtypes:
subtype
type
vsubtype
vtype
Create hash signatures for values provided:
hash signature
Excel sheet functions:
excel column
excel coordinates
excel validate sheet name