Skip to main content
Link
Menu
Expand
(external link)
Document
Search
Copy
Copied
Getting Started
Download Expressif
Expressif language
The Expressif philosophy
Expressions
Values and types
References
Functions
Input bindings
Incoming and enclosing contexts
Structured values
Predicates
Shorthands
Advanced expressions
Arrays in practice
Tuples in practice
Coercion in practice
Errors, null, and missing values
Command-line interface
Configuration
Installation
Windows installer
Evaluate an expression
Run expressions over input data
Validate expressions
Inspect parsing and binding
Interactive REPL
Automation and exit codes
Tooling
Expressif Language Server
TextMate grammar
Notepad++
Rouge
.NET SDK
Analyze field scopes
Install Expressif
Evaluate an expression
Evaluate a predication
Build an expression with C#
Build a predication with C#
Serialize a builder
Functions library
Array functions
array
Aggregation functions
broadcast
fold
scan
Combination functions
join
join-full
join-left
join-right
zip
zip-cycle
zip-padded
zip-strict
Grouping functions
group
group-by
key
pivot
unpivot
cardinality
filter
flat-map
Partitioning functions
chunk
chunk-around
chunk-on
chunk-while
distribute-condition
distribute-random-split
distribute-round-robin
distribute-weight
generate
Selection functions
closest-by
first-elements
last-elements
max-by
min-by
single
skip-first-elements
skip-last-elements
slice-elements
value-at
Sequencing functions
adjacent
lag
lead
pairwise
position-of
reverse
with-position
map
Set functions
complement
difference
distinct
intersection
symmetric-difference
union
map-over
map-with
to-tuple
Dictionary functions
dictionary
nest
Flow functions
apply
catch
guard
let
switch
throw
transform-as
transform-with
try
Grouping functions
cube
drill-down
drill-up
drop-empty-groups
filter-groups
grouping
grouping-sets
map-groups
roll-up
summarize
summarize-against
top-groups
Pair functions
pair
pair-key
pair-value
Sorting functions
ascending
bottom
bottom-with-ties
compare
compare-date
compare-datetime
compare-numeric
compare-ordinal
compare-time
dense-rank
dense-rank-by
descending
nulls-first
nulls-last
rank
rank-by
sort
sort-by
sort-key
sort-table
sort-term
top
top-with-ties
Structure functions
walk
Vector functions
distance
dot
magnitude
normalize
Io functions
creation-datetime
creation-datetime-utc
directory
extension
filename
filename-without-extension
root
size
update-datetime
update-datetime-utc
Text functions
Selection functions
after-substring
before-substring
extract-matches
first-chars
last-chars
skip-first-chars
skip-last-chars
Tokenization functions
token
token-count
token-count-lexical
tokenize
tokenize-camel
tokenize-kebab
tokenize-lexical
tokenize-lines
tokenize-pascal
tokenize-regex
tokenize-snake
tokenize-words
Casing functions
allcaps-case
camel-case
camel-snake-case
capitalize
cobol-case
dot-case
flat-case
kebab-case
lower
namespace-case
pascal-case
pascal-snake-case
path-case
screaming-snake-case
sentence-case
snake-case
swap-case
title-case
train-case
upper
parse-json
Character functions
chars
remove-chars
replace-chars
Concatenation functions
append
append-new-line
append-space
prefix
prefix-new-line
prefix-new-line-if-missing
prefix-space
prepend
prefix-space-if-missing
prepend-new-line
prepend-space
replace-slice
suffix
suffix-new-line
suffix-space
text
suffix-new-line-if-missing
suffix-space-if-missing
Conversion functions
code-point
text-to-datetime
from-code-point
Counting functions
count-distinct-chars
count-substring
length
Encoding functions
html-to-text
json-escaped-to-text
text-to-html
text-to-json-escaped
text-to-uri
text-to-xml-escaped
uri-to-text
xml-escaped-to-text
Filtering functions
filter-chars
retain-alpha
retain-alpha-numeric
retain-numeric
retain-numeric-symbol
Masking functions
mask-to-text
text-to-mask
Normalization functions
clean-whitespace
collapse-whitespace
empty-to-null
null-to-empty
slug
trim
whitespaces-to-empty
whitespaces-to-null
without-diacritics
without-whitespaces
Padding functions
pad-center
pad-left
pad-right
Partitioning functions
split-lengths
split-while
Tuple functions
arity
bind
extend
label
label-conflicts
pick
rotate
swap
tuple
tuple-at
tuple-first
tuple-second
Numeric functions
Classification functions
bucket
bucket-with-outliers
Arithmetic functions
absolute
add
cube-power
cube-root
decrement
divide
greatest-common-divisor
increment
invert
lowest-common-multiple
multiply
nth-root
oppose
percent-change
power
sign
square-power
square-root
subtract
Conversion functions
null-to-zero
Formatting functions
format-currency-prefix
format-currency-suffix
human-readable-format-binary-bytes
human-readable-format-decimal
human-readable-format-decimal-bytes
Rounding functions
ceiling
clip
floor
integer
round
Record functions
drop-null-fields
exclude-fields
expand
explode
explode-outer
field
field-names
from-pairs
implode-inner
nested-field
pairs
public
put
put-absent
put-absent-path
put-path
put-present
put-present-path
record
rename-fields
select-fields
set-private
set-public
with
Special functions
any-to-any
coalesce
coerce
coerce-boolean
coerce-date
coerce-datetime
coerce-int
coerce-numeric
coerce-text
coerce-time
neutral
null-to-value
recode
value-to-value
any-to-any
Temporal functions
age
Calendar functions
catholic-calendar
first-in-month
first-of-month
first-of-year
last-in-month
last-of-month
last-of-year
length-of-month
length-of-year
backward
Conversion functions
datetime-to-date
invalid-to-date
null-to-date
ceiling-hour
ceiling-minute
change-of-hour
change-of-minute
change-of-month
change-of-second
change-of-year
circular-distance
clamp
day-of-month
day-of-week
day-of-year
duration-between
floor-hour
floor-minute
forward
hour
hour-minute
hour-minute-second
hour-of-day
iso-day-of-year
iso-week-of-year
iso-year-day
iso-year-week
iso-year-week-day
local-to-utc
minute-of-day
minute-of-hour
month
month-day
month-of-year
next-business-days
next-day
next-month
next-weekday
next-weekday-or-same
next-year
previous-business-days
previous-day
previous-month
previous-weekday
previous-weekday-or-same
previous-year
second-of-day
second-of-hour
second-of-minute
set-time
set-to-local
set-to-utc
utc-to-local
year
year-of-era
Predicates library
Array predicates
Combination predicates
exists
is-single
Record predicates
is-absent
is-present
Special predicates
is-not-null
is-null
is-type
Tuple predicates
has-arity
is-tuple
Boolean predicates
and
implies
is-false
is-false-or-null
is-identical-to
is-true
is-true-or-null
majority
nand
nor
not
or
satisfies-at-least
satisfies-at-most
satisfies-exactly
xnor
xor
Text predicates
contains
ends-with
is-any-of
is-camel-case
is-empty
is-currency-symbol
is-empty-or-null
is-equivalent-to
is-lower-case
is-kebab-case
is-sorted-after
is-sorted-after-or-equivalent-to
is-pascal-case
is-sorted-before
is-snake-case
is-sorted-before-or-equivalent-to
is-upper-case
matches-date
matches-datetime
matches-numeric
matches-regex
matches-time
matches-currency
starts-with
Numeric predicates
is-code-point
Arithmetic predicates
has-remainder
is-divisible-by
is-even
is-odd
is-equal-to
is-greater-than
is-greater-than-or-equal
is-less-than
is-less-than-or-equal
is-negative
is-negative-or-zero
is-one
is-opposite
is-positive
is-positive-or-zero
is-whole-number
is-within-interval
is-zero
is-zero-or-null
Temporal predicates
is-after
is-after-or-same-instant
is-before
is-before-or-same-instant
is-business-day
is-contained-in
is-in-the-future
is-in-the-future-or-now
is-in-the-future-or-today
is-in-the-past
is-in-the-past-or-now
is-in-the-past-or-today
is-leap-year
is-on-the-day
is-on-the-hour
is-on-the-minute
is-same-instant
is-today
is-tomorrow
is-weekday
is-weekend
is-within-current-month
is-within-current-week
is-within-current-year
is-within-last-month
is-within-last-week
is-within-last-year
is-within-next-days
is-within-previous-days
is-within-upcoming-month
is-within-upcoming-week
is-within-upcoming-year
is-yesterday
Accumulators library
Array accumulators
any
closest
common-prefix
common-suffix
count
every
first
last
max
min
only
reduce
sum
Text accumulators
concat
Deprecations and sunsets
Timeline
Brand colors
Thanks
Tuple binding
Search Expressif
Home
Docs
Download
Timeline
Contact
Issue tracking
View on GitHub
Predicates library
Reference documentation for all available Expressif predicates.
← Previous
Functions library
Next →
Accumulators library
Table of contents
Array predicates
Record predicates
Special predicates
Tuple predicates
Boolean predicates
Text predicates
Numeric predicates
Temporal predicates