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 Filter7 %
- GroupBy5 %
- Column Rename (Regex)5 %
- Column List Loop Start3 %
- Pivot3 %
Column Rename3 %- Excel Reader3 %
- Joiner3 %
- Row Filter3 %
- Table Transposer2 %
- Column Splitter2 %
Table Row to Variable2 %- Column Resorter2 %
- String Manipulation1 %
- Math Formula1 %
- String Manipulation (Variable)1 %
- Duplicate Row Filter1 %
- Rule Engine1 %
- CSV Reader1 %
String To Number1 %- RowID1 %
Cell Splitter1 %- Math Formula (Multi Column)1 %
- Rule-based Row Filter1 %
- Cell Splitter1 %
- Concatenate< 1 %
- Column Expressions< 1 %
- Column Renamer< 1 %
- Constant Value Column< 1 %
Table Column to Variable< 1 %- Missing Value< 1 %
- Reference Column Filter< 1 %
- Table Row to Variable Loop Start< 1 %
- Parquet Reader< 1 %
- String to Date&Time< 1 %
- DB Reader< 1 %
- JSON to Table< 1 %
- String to Number< 1 %
- Row Splitter< 1 %
- File Reader< 1 %
- Sorter< 1 %
- String Manipulation (Multi Column)< 1 %
- Split Collection Column< 1 %
- Missing Value Column Filter< 1 %
Concatenate (Optional in)< 1 %- Table Creator< 1 %
- Rule-based Row Splitter< 1 %
- Variable Expressions< 1 %
Variable to Table Column< 1 %- Table Row to Variable< 1 %
- Column Appender< 1 %
- Column Name Extractor< 1 %
Joiner< 1 %- Ungroup< 1 %
- Loop End< 1 %
- Regex Split< 1 %
- String Replacer< 1 %
- Number to String< 1 %
- Group Loop Start< 1 %
- Column Aggregator< 1 %
- Value Counter< 1 %
- Chunk Loop Start< 1 %
- Counter Generation< 1 %
Extract Date&Time Fields< 1 %- Loop End (Column Append)< 1 %
- Column Auto Type Cast< 1 %
- Reference Column Splitter< 1 %
- Table Manipulator< 1 %
- Unpivot< 1 %
- DB Query Reader< 1 %
- Table Reader< 1 %
- Extract Table Dimension< 1 %
- JSON Path< 1 %
- Lag Column< 1 %
- Parallel Chunk Start< 1 %
- Column Filter (legacy)< 1 %
- Moving Average< 1 %
- Gradient Boosted Trees Predictor< 1 %
Excel Reader (XLS)< 1 %Regex Extractor< 1 %- Double to Integer< 1 %
- Java Edit Variable (simple)< 1 %
Table Row to Variable< 1 %Variable to Table Row< 1 %- Column Renamer (Dictionary)< 1 %
String Replace (Dictionary)< 1 %- End IF< 1 %
- Feature Calculator (BETA)< 1 %
Column Filter Configuration< 1 %- Cross Joiner< 1 %
Excel Reader (XLS)< 1 %- Java Edit Variable< 1 %
Merge Variables< 1 %XLS Reader< 1 %- Column Filter Configuration< 1 %
- Don't Save Start< 1 %
- Table Column to Variable< 1 %
- Merge Variables< 1 %
- Numeric Binner< 1 %
Python Script (2⇒1)< 1 %- Regression Predictor< 1 %
File Reader< 1 %Recursive Loop End< 1 %Numeric Scorer< 1 %- Add Empty Rows< 1 %
- Column Merger< 1 %
- Reference Column Resorter< 1 %
Python Script (1⇒1)< 1 %- Breakpoint< 1 %
Generic Loop Start< 1 %- Parameterized DB Query Reader< 1 %
- String Configuration< 1 %
- Date&Time Difference< 1 %
- Recursive Loop End< 1 %
- Row to Column Names< 1 %
- CASE Switch End< 1 %
- Column Combiner< 1 %
- One to Many< 1 %
- Nominal Value Row Filter< 1 %
- Reference Row Filter< 1 %
- Date&Time Shift< 1 %
Database Looping< 1 %- Column Selection Configuration< 1 %
- Recursive Loop Start< 1 %
- Row Filter (Labs)< 1 %
- Variable Loop End< 1 %
- Image to Table< 1 %
CSV Reader< 1 %Database Connection Table Reader< 1 %- Constant Value Column Filter< 1 %
- Normalizer< 1 %
- Statistics< 1 %
- R Snippet< 1 %
- Moving Aggregator< 1 %
- DB Insert< 1 %
- Modify Time< 1 %
- Counting Loop Start< 1 %
- CASE Switch Start< 1 %
- Shape Manager< 1 %
- Regex Substring< 1 %
Recursive Loop Start< 1 %- Set Operator< 1 %
- Cache< 1 %
Simple File Reader< 1 %- SDF Reader< 1 %
- Google Sheets Reader< 1 %
- Variable to Table Column< 1 %
- Image Writer (Port)< 1 %
- Variable Creator< 1 %
- SAP Reader (Theobald Software)< 1 %
- Regex Extractor< 1 %
- MolSimilarity< 1 %
Database Reader< 1 %Cell Replacer< 1 %- Rank< 1 %
- Round Double< 1 %
- Empty Table Switch< 1 %
- IF Switch< 1 %
- Math Formula (Variable)< 1 %
- String Input (legacy)< 1 %
- Python Edit Variable (legacy)< 1 %
- Date&Time-based Row Filter< 1 %
IF Switch (Flow Variable Value)< 1 %- Wait...< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Color Manager< 1 %
- Fast Fourier Transform (FFT)< 1 %
- Target Shuffling< 1 %
- Path to String< 1 %
- Python Script (legacy)< 1 %
- Variable Condition Loop End< 1 %
- DB Looping< 1 %
- Scorer< 1 %
- Fingerprints Expander< 1 %
- Inject Variables (Data)< 1 %
- Java Snippet< 1 %
Loop End< 1 %- k-Means< 1 %
- Auto-Binner< 1 %
- Category to Number< 1 %
Column Appender< 1 %- Create Table Structure< 1 %
- Row Sampling< 1 %
CASE Switch Data (End)< 1 %CASE Switch Data (Start)< 1 %- Scatter Plot (legacy)< 1 %
- Java Snippet (simple)< 1 %
Strings To Document< 1 %- Date Field Extractor (legacy)< 1 %
- RDKit Canon SMILES< 1 %
- RDKit Descriptor Calculation< 1 %
- Scale Distributions< 1 %
- Catch Errors (Data Ports)< 1 %
- Numeric Scorer< 1 %
- Column to Grid< 1 %
- Rule Engine Variable< 1 %
- Single Selection Configuration< 1 %
- Table View (JavaScript)< 1 %
- Python Source (legacy)< 1 %
- Date&Time to String< 1 %
- Variable to Table Row< 1 %
- File Reader (Complex Format)< 1 %
- String to Number (PMML)< 1 %
- Column Selection Widget< 1 %
- Extract Date&Time Fields< 1 %
- Table Writer< 1 %
- String to JSON< 1 %
- Inject Column Properties< 1 %
- Price Sensitivity< 1 %
- Generic Loop Start< 1 %
- RDKit Substructure Filter< 1 %
- MultiLayerPerceptron Predictor< 1 %
Number To String< 1 %- Numeric Row Splitter< 1 %
- Data Generator< 1 %
- H2O to Table< 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 %
- Create Date&Time Range< 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 %
- Reference Row Splitter< 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 %- POST Request< 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 %
- Extract Properties< 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 %
- Salesforce Simple Query< 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
- (3D) Fragment library design workflowKNIME Hub
- 00 Data GenerationKNIME Hub
- 00 Main MenuKNIME Hub
- Show all 1472 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.