Introduction Actions task Base env shell Base env shell task Conda env live task Conda env shell Conda env task Converter Create a sugar type of food Create report Create robot Dataset exporter Dataset importer Dispatch2 Download resource from a S3 bucket Download resource from external source Eat task Encoded table exporter Encoded table importer EncodingTable exporter EncodingTable importer Env live task Fifo2 Fly task Fs node extractor JSON Dict exporter JSON Dict importer Mamba env live task Mamba env task MetadataTable exporter MetadataTable importer Move robot Pip env live task Pip env shell Pip env task Python live task R conda env live task R mamba env live task Resource exporter Resource importer Resource picker Resource set exporter Resource stacker Robot add Select report Shell Shell task Shell wait Sink Smart interactive plot generator Smart json transformer Smart plot generator Smart table transformer Source Switch2 Table aggregator Table aggregator filter Table annotator Table column aggregator Table column aggregator filter Table column annotator Table column concat Table column data numeric filter Table column data text filter Table column operation mass Table column operations Table column scaler Table column tag aggregator Table column tag extractor Table column tag unfolder Table column tags deleter Table column tags selector Table columns deleter Table columns selector Table decoder Table encoder Table exporter Table filter Table filter Table importer Table replace Table row aggregator Table row aggregator filter Table row annotator Table row concat Table row data numeric filter Table row data text filter Table row scaler Table row tag aggregator Table row tag extractor Table row tag unfolder Table row tags deleter Table row tags selector Table rows deleter Table rows selector Table scaler Table to dataset converter Table transposer Task Text exporter Text importer The travel of `Astro` Transformer Uncompress file Upload resource to S3 Viewer Wait Wait task Write to file
Technical Documentation
Resources
Tasks
Protocols
Table column data text filter
Filters the table columns based on values of one or multiple rows with text comparator
For earch filters, the system will keep the columns where the value in the row provided by the parameter ```Row name``` validated condition (the ```comparator``` with the ```value``` parameter).The result table will have the same number of rows as the input table.
The ```Row name``` supports pattern. This means that multiple rows can be used in the filter. In this
case all the values in the provided rows must validate the condition. You can set the value ```*``` in the ```Row name``` which mean that all the values in the column must validate the condition.
Supported operators : ```=```, ```!=```, ```contains```, ```contains not```, ```startwith``` and ```endswith```.
If you need to apply filters on text values, you can use the Table column data text filter task.
Input
Table
2d excel like table
Output
Table
2d excel like table
Configuration
text_filter
List9row_name_regex
The name of the rows along which the filter is applied (regexp pattern); Use '*' for all the rows
stringcomparator
Comparator
string= != contains contains notstartswith endswith value
Value
string