0

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

Reply

null