# utility functions

Helpers that do not belong to one calculation domain.

27 functions.

- [FROMBYTES](https://deepcalc.com/docs/functions/frombytes.md): converts byte array to integer
- [GENERATEID](https://deepcalc.com/docs/functions/generateid.md): generates unique ID with prefix and random suffix
- [HASH](https://deepcalc.com/docs/functions/hash.md): hex digest of text: SHA256 (default, FIPS 180-4) or MD5 (RFC 1321)
- [IMAGE](https://deepcalc.com/docs/functions/image.md): shows an image from a url: the browser loads it, the engine does not fetch
- [ISIN](https://deepcalc.com/docs/functions/isin.md): checks if value is in a range or comma-separated list
- [RANDOMCHOICE](https://deepcalc.com/docs/functions/randomchoice.md): random pick from a range (with replacement); count > 1 spills a column
- [RANDOMINT.UNIQUE](https://deepcalc.com/docs/functions/randomint-unique.md): generates unique random integers in range
- [RANDOMNORMAL](https://deepcalc.com/docs/functions/randomnormal.md): generates random values from normal distribution
- [SPARKLINE](https://deepcalc.com/docs/functions/sparkline.md): draws a mini line or bar chart from a range: options take charttype, color, negcolor, linewidth, ymin and ymax
- [TIMESTAMP](https://deepcalc.com/docs/functions/timestamp.md): current timestamp in milliseconds since epoch
- [TO_DATE](https://deepcalc.com/docs/functions/to-date.md): reads a number as a date serial
- [TO_DOLLARS](https://deepcalc.com/docs/functions/to-dollars.md): reads a number as a currency amount
- [TO_PERCENT](https://deepcalc.com/docs/functions/to-percent.md): reads a number as a percentage
- [TO_PURE_NUMBER](https://deepcalc.com/docs/functions/to-pure-number.md): strips formatting and returns the underlying number
- [TO_TEXT](https://deepcalc.com/docs/functions/to-text.md): converts a value to text
- [TOARRAY](https://deepcalc.com/docs/functions/toarray.md): materializes a range as a dynamic array (spills)
- [TOBOOL](https://deepcalc.com/docs/functions/tobool.md): converts value to boolean
- [TODATE](https://deepcalc.com/docs/functions/todate.md): parses text (YYYY-M-D, YYYY/M/D, M/D/YYYY, D.M.YYYY) to a date serial
- [TONUMBER](https://deepcalc.com/docs/functions/tonumber.md): converts value to number; unparseable text returns default when given, else #VALUE!
- [TOTEXT](https://deepcalc.com/docs/functions/totext.md): converts value to text representation
- [TOTIME](https://deepcalc.com/docs/functions/totime.md): parses \"HH:MM\" or \"HH:MM:SS\" text to a time fraction of day
- [UUID](https://deepcalc.com/docs/functions/uuid.md): generates UUID v4 string
- [VALIDATE.DATE](https://deepcalc.com/docs/functions/validate-date.md): validates date components form valid date
- [VALIDATE.EMAIL](https://deepcalc.com/docs/functions/validate-email.md): validates email address format
- [VALIDATE.PHONE](https://deepcalc.com/docs/functions/validate-phone.md): validates phone number format
- [VALIDATE.RANGE](https://deepcalc.com/docs/functions/validate-range.md): validates value is within min and max range
- [VALIDATE.URL](https://deepcalc.com/docs/functions/validate-url.md): validates URL format

## navigate

- [function index](https://deepcalc.com/docs/functions.md)
- [error values](https://deepcalc.com/docs/errors.md) · [concepts](https://deepcalc.com/docs/concepts.md) · [limits](https://deepcalc.com/docs/limits.md)

source: https://deepcalc.com/docs/functions/utility-functions