Type Conversion and Formatting

Prev Next

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

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

parameter set conversion function:
    parameter set

Identify optimum data type for value provided:
    best type

Join parameter set elements into a string:
    join
    join ignore blanks
    join unique
    join unique ignore blanks

Identify variable types and subtypes:
    subtype
    type

Create hash signatures for values provided:
    hash signature

Excel sheet functions:
    excel column
    excel coordinates
    excel validate sheet name