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:​
col | col2 |
---|---|
LOREM IPSUM asdf | something else |
Results after regex stage:​
col | col2 |
---|---|
LOREM IPSUM asdf | something else |
Query​
seed '[{"col": "LOREM IPSUM asdf", "col2": "something else"}]'
|| regex "[a-z]+" --match --column col
Results prior to regex stage:​
col | col2 |
---|---|
LOREM IPSUM asdf | something else |
Results after regex stage:​
col | col2 | _match0 |
---|---|---|
LOREM IPSUM asdf | something else | sadf |
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