Format and convert data

An overview of functions to help you format and convert data types

appointment

To convert given time-related values to an appointment

array

To create a new array by merging 2 arrays of a similar type

createXLSX

To dynamically create customizable, styled, multi-sheet Excel files directly from databases

date

To convert to or return a date value

datetime

To convert to or return a timestamp

email

To convert a given value to an email value

format

To format a given value

formatJSON

To create a JSON string of a valid JSON object

formatXML

To convert a given JSON object into XML text, which might be optically structured

html

To return a rich text representation of any value

loadFileAsBase64

To convert a file to base64 format

loadFileAsBase64URL

To convert a file to URL-compliant base64 format

lower

To return a string in lower case

monthIndex

To return a given month as a number out of a string

monthName

To return the full month name of a given date value

number

To convert a given value to a number

parseJSON

To convert a JSON string to a JSON object

parseXML

To convert an XML string to a JSON object

phone

To convert a number or string to a phone value

removeItem

To remove a key-value pair from a given JSON object

setItem

To update or add a key-value pair in a given JSON object

string

To convert a given value to a string

styled

To convert a given string to a styled object

text

To convert a value to a string and possibly reflect the format options

timeinterval

To convert a given time-related value to a time interval, i.e. a duration

timestamp

To convert a given time-related value to a timestamp

upper

To return a string in the upper case

url

To convert a string to a link