POSIX stands for Portable Operating System Interface. It defines a set of standard operating system interfaces based on the UNIX OS.

In POSIX Basic Regex syntax, most characters are treated as literals, i.e., they match only themselves. But, there are some exceptions, which are called Metacharacters.

FunctionsDescription
.Matches any single character. For example, a.c matches ”abc”, but [a.c] matches only ”a”, ”.”, or ”c“.
-Used to define a range. For example, [a-c] will match characters a to c (both inclusive).
[]Calculates and returns a value corresponding to the minimal metric in the same row from a set of values.
^Calculates and returns the maximum value.
$Calculates and Returns a value corresponding to the maximum metric in the same row from a set of values.
*Calculates and returns the average value.
{n}Counts the number of rows.
{n,m}Calculates the boolean of all the boolean values in the aggregated group. FALSE if at least one of aggregated rows is FALSE
REGEXP_REPLACEREPLACE