Renames all columns based on a regular expression search & replace pattern. The search pattern is a regular expression, possibly containing groups for further back referencing in the replace field.
In the simplest case, you can search and replace string literals. E.g. if the input columns are called "Foo 1", "Foo 2", "Foo 3", etc and the search string is "Foo", the replacement is "Bar", the output would be "Bar 1", "Bar 2", "Bar 3".
More complicated cases contain
capturing groups, i.e. expressions in parentheses that, if
matched in a column name, are saved. The groups can be referenced
in the replacement string using $g, whereby g
is a number 0-9. These placeholders will be replaced by the
original occurrence in the input column name.
For instance, to rename the columns that are produced by the
Data Generator node (they follow a scheme
Universe_<number1>_<number2>) to
<number2> (Uni <number1>), you would use as
search string: "Universe_(\d+)_(\d+)" and as replacement:
"$2 (Uni $1)".
The special sequence $i represents the current column
index (unless escaped by '\' (backslash)). E.g. in order to
precede each column name with the column index, use as search
string "(^.+$)", capturing the entire column name in a group,
and as replacement "$i: $1".
Further documentation regarding regular expressions can be found in the Java API documentation, in particular the classes Pattern and Matcher.
Options
Popular Predecessors
- Column Filter6 %
- GroupBy5 %
- Column Rename (Regex)5 %
- Pivot3 %
- Joiner3 %
Column Rename3 %- Column List Loop Start3 %
Table Row to Variable2 %- Excel Reader2 %
- Table Transposer2 %
Row Filter (deprecated)2 %- Column Resorter2 %
String To Number2 %Cell Splitter2 %- CSV Reader1 %
- Rule-based Row Filter1 %
- Column Splitter1 %
- Rule Engine1 %
- Concatenate1 %
Table Column to Variable1 %- Cell Splitter1 %
- String Manipulation1 %
- Math Formula1 %
- Duplicate Row Filter1 %
- Math Formula (Multi Column)< 1 %
- Missing Value< 1 %
- RowID< 1 %
- Column Expressions< 1 %
Concatenate (Optional in)< 1 %- Constant Value Column< 1 %
Variable to Table Column< 1 %- String Manipulation (Variable)< 1 %
- String Manipulation (Multi Column)< 1 %
- Reference Column Filter< 1 %
- Column Appender< 1 %
- Column Renamer (Dictionary)< 1 %
Joiner< 1 %- String to Number< 1 %
- Column Renamer< 1 %
Row Splitter (deprecated)< 1 %- Table Row to Variable Loop Start< 1 %
- Table Row to Variable< 1 %
- Split Collection Column< 1 %
- Table Reader< 1 %
- File Reader< 1 %
- Group Loop Start< 1 %
Extract Date&Time Fields< 1 %- Table Creator< 1 %
- Reference Column Splitter< 1 %
- Missing Value Column Filter< 1 %
- Sorter< 1 %
- Extract Table Dimension< 1 %
- Loop End (Column Append)< 1 %
- Parallel Chunk Start< 1 %
- Column Filter (legacy)< 1 %
- JSON to Table< 1 %
- String to Date&Time< 1 %
- Moving Average< 1 %
- Gradient Boosted Trees Predictor< 1 %
- Variable Expressions< 1 %
Excel Reader (XLS)< 1 %Regex Extractor< 1 %- Ungroup< 1 %
Table Row to Variable< 1 %- Parquet Reader< 1 %
Variable to Table Row< 1 %String Replace (Dictionary)< 1 %- Feature Calculator (BETA)< 1 %
- DB Query Reader< 1 %
Column Filter Configuration< 1 %- Column Name Extractor< 1 %
Excel Reader (XLS)< 1 %- DB Reader< 1 %
- Unpivot< 1 %
Merge Variables< 1 %XLS Reader< 1 %- Don't Save Start< 1 %
- Variable Creator< 1 %
- Table Manipulator< 1 %
- Chunk Loop Start< 1 %
- Numeric Binner< 1 %
- Column Aggregator< 1 %
Python Script (2⇒1)< 1 %- Regression Predictor< 1 %
- Loop End< 1 %
File Reader< 1 %Recursive Loop End< 1 %Numeric Scorer< 1 %- Lag Column< 1 %
- Reference Column Resorter< 1 %
Python Script (1⇒1)< 1 %- Breakpoint< 1 %
Generic Loop Start< 1 %- Parameterized DB Query Reader< 1 %
- Recursive Loop End< 1 %
- Column Auto Type Cast< 1 %
- Column Combiner< 1 %
- Value Counter< 1 %
- Rule-based Row Splitter< 1 %
- Date&Time Difference< 1 %
- Image to Table< 1 %
CSV Reader< 1 %Database Connection Table Reader< 1 %Database Reader< 1 %- Constant Value Column Filter< 1 %
- Number to String< 1 %
- DB Insert< 1 %
- Table Column to Variable< 1 %
- Row Filter (Labs)< 1 %
- Shape Manager< 1 %
Recursive Loop Start< 1 %- Column Merger< 1 %
- Double to Integer< 1 %
- String Splitter (Regex)< 1 %
- Set Operator< 1 %
- Cache< 1 %
- JSON Path< 1 %
- Google Sheets Reader< 1 %
- String Configuration< 1 %
- File Reader (Complex Format)< 1 %
- Image Writer (Port)< 1 %
- SAP Reader (Theobald Software)< 1 %
- Regex Extractor< 1 %
- MolSimilarity< 1 %
- Normalizer< 1 %
- Rank< 1 %
- String Replacer< 1 %
- Statistics< 1 %
- Counter Generation< 1 %
- Math Formula (Variable)< 1 %
- String Input (legacy)< 1 %
- Python Edit Variable (legacy)< 1 %
- POST Request< 1 %
- Date&Time-based Row Filter< 1 %
- Date&Time Shift< 1 %
IF Switch (Flow Variable Value)< 1 %- Wait...< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Color Manager< 1 %
- SDF Reader< 1 %
- Create Date&Time Range< 1 %
- Fast Fourier Transform (FFT)< 1 %
- Target Shuffling< 1 %
- Path to String< 1 %
- Salesforce Simple Query< 1 %
- Date&Time Part Extractor< 1 %
- Variable Condition Loop End< 1 %
- DB Looping< 1 %
- Scorer< 1 %
- Fingerprints Expander< 1 %
- Inject Variables (Data)< 1 %
- Java Edit Variable< 1 %
- Java Snippet< 1 %
Loop End< 1 %- k-Means< 1 %
- Add Empty Rows< 1 %
- Auto-Binner< 1 %
Cell Replacer< 1 %- Category to Number< 1 %
Column Appender< 1 %- One to Many< 1 %
- Create Table Structure< 1 %
- Cross Joiner< 1 %
- Nominal Value Row Filter< 1 %
- Reference Row Filter< 1 %
- Reference Row Splitter< 1 %
- Number Rounder< 1 %
- Row Sampling< 1 %
- Empty Table Switch< 1 %
CASE Switch Data (End)< 1 %- End IF< 1 %
- IF Switch< 1 %
CASE Switch Data (Start)< 1 %- Scatter Plot (legacy)< 1 %
- H2O to Table< 1 %
- Java Snippet (simple)< 1 %
- Java Edit Variable (simple)< 1 %
Strings To Document< 1 %- R Snippet< 1 %
- Date Field Extractor (legacy)< 1 %
- Moving Aggregator< 1 %
- RDKit Canon SMILES< 1 %
- RDKit Descriptor Calculation< 1 %
- Scale Distributions< 1 %
- Catch Errors (Data Ports)< 1 %
Database Looping< 1 %Simple File Reader< 1 %- Numeric Scorer< 1 %
- Column to Grid< 1 %
- Rule Engine Variable< 1 %
- Column Filter Configuration< 1 %
- Column Selection Configuration< 1 %
- Single Selection Configuration< 1 %
- Table View (JavaScript)< 1 %
- Python Source (legacy)< 1 %
- Date&Time to String< 1 %
- Modify Time< 1 %
- Variable to Table Column< 1 %
- Variable to Table Row< 1 %
- Counting Loop Start< 1 %
- Recursive Loop Start< 1 %
- String to Number (PMML)< 1 %
- CASE Switch Start< 1 %
- Merge Variables< 1 %
- Column Selection Widget< 1 %
- Python Script (legacy)< 1 %
- Table Writer< 1 %
- String to JSON< 1 %
- Row to Column Names< 1 %
- CASE Switch End< 1 %
- Inject Column Properties< 1 %
- Price Sensitivity< 1 %
- Variable Loop End< 1 %
- Generic Loop Start< 1 %
- RDKit Substructure Filter< 1 %
- Regex Substring< 1 %
- MultiLayerPerceptron Predictor< 1 %
Number To String< 1 %- Numeric Row Splitter< 1 %
- Data Generator< 1 %
- Document Data Extractor< 1 %
- Column Selection (legacy)< 1 %
- XPath< 1 %
- Molecule Properties< 1 %
- URL to File Path< 1 %
Parameterized Database Query< 1 %List Files< 1 %- Partitioning< 1 %
- Double Input (legacy)< 1 %
- Multiple Selections (legacy)< 1 %
- Double Widget< 1 %
- Collection to String< 1 %
- ROC Curve (legacy)< 1 %
- Similarity Calculator< 1 %
- URL to File Path (Variable)< 1 %
CSV Writer< 1 %Table Reader< 1 %Double To Int< 1 %- Missing Value (Apply)< 1 %
- Extract Table Spec< 1 %
- R to Table< 1 %
- Date&Time to legacy Date&Time< 1 %
Loop End (Upto 4 ports)< 1 %PCA Apply< 1 %- Expand Bit Vector< 1 %
- Shuffle< 1 %
CASE Switch Variable (Start)< 1 %- Crosstab< 1 %
- Scorer (JavaScript)< 1 %
JSON Reader< 1 %- Parameter Optimization Loop End< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Modify Time Zone< 1 %
Flow Variable End IF< 1 %- Line Reader< 1 %
- Random Forest Predictor (Regression)< 1 %
- Number to Category (Apply)< 1 %
- Top k Row Filter< 1 %
- Create File/Folder Variables< 1 %
- Boolean Configuration< 1 %
- List Box Widget< 1 %
- RDKit Substructure Counter< 1 %
- Domain - Similarity< 1 %
- Create Collection Column< 1 %
Table Row To Variable Loop Start< 1 %Interval Loop Start< 1 %- SVM Predictor< 1 %
- Case Converter< 1 %
- Column Comparator< 1 %
Linear Correlation< 1 %- Correlation Filter< 1 %
- Domain Calculator< 1 %
- Low Variance Filter< 1 %
- Normalizer Apply (PMML)< 1 %
- Data Explorer< 1 %
- Parallel Chunk End< 1 %
- Similarity Search< 1 %
- Punctuation Erasure< 1 %
- Boolean Input (legacy)< 1 %
Python Script (1⇒1)< 1 %Python Edit Variable< 1 %Python Script (2⇒2)< 1 %- Time Difference (legacy)< 1 %
- Fingerprint Similarity< 1 %
- RDKit Fingerprint< 1 %
Ranking Services< 1 %Table Extractor< 1 %Loop End (3 ports)< 1 %Variable to Table Column< 1 %Table Column to Variable< 1 %Counting Loop Start< 1 %- Decision Tree Predictor< 1 %
- Edit Nominal Domain< 1 %
- Denormalizer (PMML)< 1 %
Parquet Reader< 1 %- H2O MOJO Predictor (Regression)< 1 %
- LIBSVMPredictor< 1 %
Excel Sheet Appender (XLS)< 1 %- N Chars Filter< 1 %
- Strings to Document< 1 %
- CSS Editor< 1 %
- List Box Input (legacy)< 1 %
- Column Filter Widget< 1 %
- Columns to JSON< 1 %
- R Source (Table)< 1 %
- Legacy Date&Time to Date&Time< 1 %
- XGBoost Predictor< 1 %
- XGBoost Predictor (Regression)< 1 %
- Molecular Properties< 1 %
- HTML Parser< 1 %
Extract Outer/InnerHTML< 1 %- PDB Sequence Extractor< 1 %
- Rule Engine (Dictionary)< 1 %
- DB SQL Executor< 1 %
- Term to String< 1 %
- Python Predictor (legacy)< 1 %
- XML Reader< 1 %
- Canonical SMILES< 1 %
Flow Variable IF Switch< 1 %Flow Variable IF Switch (Flow Variable Value)< 1 %- Table Row To Variable Run-for-time Loop Start< 1 %
- MolImporter< 1 %
- ARIMA Predictor< 1 %
- Binary Objects to PNGs< 1 %
- Extract Variables (Data)< 1 %
Recursive Loop Start (2 ports)< 1 %Scorer< 1 %- Cell Splitter By Position< 1 %
- Extract Missing Value Cause< 1 %
- Normalizer (Apply)< 1 %
- Normalizer (PMML)< 1 %
Excel Reader (XLS)< 1 %- Java IF (Table)< 1 %
- Integer Input (legacy)< 1 %
- Value Selection (legacy)< 1 %
- Labeling Filter< 1 %
- ImageJ Macro< 1 %
Column Selection QuickForm (legacy)< 1 %- Date/Time Shift (legacy)< 1 %
- Time Generator (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- Time to String (legacy)< 1 %
- Country Extractor< 1 %
- Remove Empty Rows< 1 %
- Fingerprint to String< 1 %
- Chunk Loop Run-for-time Loop Start< 1 %
- R Snippet< 1 %
- R Snippet (2:1)< 1 %
- String to URI< 1 %
- Try (Data Ports)< 1 %
- Try (Variable Ports)< 1 %
Table Column to Variable< 1 %Variable to Table Row< 1 %- ARFF Reader< 1 %
Database Column Filter< 1 %Database SQL Executor< 1 %Database Writer< 1 %SQL Extract< 1 %Table Writer< 1 %Recursive Loop End (2 ports)< 1 %- X-Partitioner< 1 %
- Naive Bayes Learner< 1 %
- Naive Bayes Predictor< 1 %
- PNN Predictor< 1 %
- Cluster Assigner< 1 %
- Logistic Regression Predictor< 1 %
- Polynomial Regression Learner< 1 %
- PCA Apply< 1 %
- PCA< 1 %
Random Forest Predictor< 1 %- Gradient Boosted Trees Predictor (Regression)< 1 %
- Tree Ensemble Predictor< 1 %
- Random Forest Predictor< 1 %
- Simple Regression Tree Predictor< 1 %
- Perl Scripting< 1 %
- Category to Number (Apply)< 1 %
- Table Validator (Reference)< 1 %
- Filter Apply< 1 %
- Nominal Value Row Splitter< 1 %
- Denormalizer< 1 %
- Column Filter (PMML)< 1 %
- One to Many (PMML)< 1 %
Number To String (PMML)< 1 %- Rule-based Row Splitter (Dictionary)< 1 %
- Numeric Outliers< 1 %
- Conditional Box Plot (legacy)< 1 %
Color Appender< 1 %- Interactive Table (legacy)< 1 %
- PMML Transformation Apply< 1 %
- Molecule Type Cast< 1 %
- SDF Extractor< 1 %
- 2D Density Plot (Plotly)< 1 %
- DL4J Feedforward Predictor (Regression) (legacy)< 1 %
- Geo-Coordinate Row Filter< 1 %
- Java Snippet Row Filter< 1 %
- Java Snippet Row Splitter< 1 %
- RegEx Filter< 1 %
- Replacer< 1 %
- Document Vector< 1 %
- String to Term< 1 %
- Weka Predictor (3.7)< 1 %
- Google Analytics Query (legacy)< 1 %
- Integer Configuration< 1 %
- Value Filter (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
- Table Editor (JavaScript)< 1 %
Column Filter Widget< 1 %- String Widget< 1 %
- Table to JSON< 1 %
- Edge Table< 1 %
- Parameter Optimization Loop Start< 1 %
Python Script (1⇒2)< 1 %- R Predictor< 1 %
- Window Loop Start< 1 %
- Preset Date/Time (legacy)< 1 %
- Twitter Users< 1 %
- String to XML< 1 %
- Table to HTML String< 1 %
- Fingerprints< 1 %
Location Extractor< 1 %Hash Calculator< 1 %- Hash Calculator< 1 %
- Timed Loop End (1 port)< 1 %
- Fix Column Names< 1 %
- Binary Objects to Files< 1 %
- File Meta Info (legacy)< 1 %
- Read Images< 1 %
Variable Condition Loop End< 1 %- X-Aggregator< 1 %
- Linear Regression Learner< 1 %
- Binner (Dictionary)< 1 %
- Linear Correlation< 1 %
- Number to String (PMML)< 1 %
- Workflow Executor< 1 %
- SDF Stripper< 1 %
- Random Number Assigner< 1 %
- Line Plot (Plotly)< 1 %
- PMML Predictor< 1 %
- List Files/Folders< 1 %
- Files/Folders Meta Info< 1 %
- Path to String (Variable)< 1 %
- Single Selection (legacy)< 1 %
- Date Extractor< 1 %
- Latitude/Longitude to Coordinate< 1 %
- HTTP Result Data Extractor< 1 %
Views
- This node has no views
Workflows
_01_PMR_AnalysisKNIME Hub- _Looping_over_all_columns_and_manipulation_of_each 1KNIME Forum
- !Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub
- (3D) Fragment library design workflowKNIME Hub
- 0_install_AI_extensionsKNIME Hub
- Show all 1648 workflows
Links
- XML to CSV / Table conversion without using XPathby qqilihq on 2021-05-28forum.knime.com/p/124945
- KNIME nodes corrupting on multiple computersby s.roughley on 2019-01-29forum.knime.com/p/53718
- Math Formula - Using column headings with ‘$’by armingrudd on 2020-02-13forum.knime.com/p/81478
- Generalise Work Flowby quaeler on 2019-07-17forum.knime.com/p/65759
- Number to String enforcing not workingby JanDuo on 2020-06-15forum.knime.com/p/94317
- Show all 6 links
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.