Skip to main content

regex

regex [regex expression]

Returns rows from the previous stage results containing the provided regex pattern.

arguments:​

regex​

A regex pattern to search for in the previous results. (type: string)

examples:​

Query​

seed '[{"col": "LOREM IPSUM asdf", "col2": "something else"}]'
|| regex "[a-z]+"

Results prior to regex stage:​

colcol2
LOREM IPSUM asdfsomething else

Results after regex stage:​

colcol2
LOREM IPSUM asdfsomething else

Query​

seed '[{"col": "LOREM IPSUM asdf", "col2": "something else"}]'
|| regex "[a-z]+" --match --column col

Results prior to regex stage:​

colcol2
LOREM IPSUM asdfsomething else

Results after regex stage:​

colcol2_match0
LOREM IPSUM asdfsomething elsesadf

flags:​

--appendStage​

Used to append the results from a previous stage to the current stage. (provide a label, stage index, or boolean true to append the previous results)

--cache​

A boolean value of true/false that determines whether or not to use the cache. Generally most commands will default to true.

--checkpoint​

Format: "{CHECKPOINT NAME}:{COLUMN}" Used to store the value of the provided column (in the first row of results) in the provided name for use as a checkpoint in scheduled queries or other stages. Can be accessed using $CHECKPOINTS.{CHECKPOINT NAME}$

--column​

The column to test in.

--filter​

A filter to run on the command results before completing the command. If not provided, no filter is run on the results.

--guid​

Adds a populated random guid column.

--labelStage​

Used to label a stage with a user provided label.

--match​

When true, will extract out matches.

--randomizeHash​

Randomizes the stage hash, even if args and flags are the same.

--stats​

Controls if a stats calculation is run on a stage after it completes.

--table​

A comma separated list of columns to include in the command results. If not provided, all columns will be included.

support​

AMI_ENTERPRISE AMI_FREE AMI_PRO BINARY_ENTERPRISE BINARY_FREE BINARY_PRO DESKTOP_ENTERPRISE DESKTOP_FREE DESKTOP_PRO DOCKER_ENTERPRISE DOCKER_FREE DOCKER_PRO