Manipulates strings like search and replace, capitalize or remove leading and trailing white spaces.
Examples:
To remove leading and trailing blanks from a column with name
c0 you would use the expression:
strip($c0$)
If you have your customer names in column names
with titles Mr and Mister and you
want to normalize the data so that only Mr is used you could
use the expression:
replace($names$, "Mister", "Mr")
or you could combine it to
replace(replace($names$, "Mister", "Mr"), "Miss", "Ms")
Or if you want to have the number of characters of the strings
in a column with name text:
length($text$)
Note that strings which are part of the expression and are not from the input data (or the result of another wrapped function call) need to be enclosed in double quotes ('"'). Additionally, if the string contains a quote character, it must be escaped using a backslash character ('\"'). Finally, other special characters such as single quotes and backslashes need to be escaped using a backslash. For instance, a single backslash in a string is written as two consecutive backslash characters; the first one acts as the escape character for the second.
Options
Popular Successors
- String Manipulation11 %
- GroupBy6 %
- Column Filter5 %
- Rule Engine5 %
- Concatenate5 %
Row Filter (deprecated)5 %- String to Date&Time4 %
- String to Number3 %
- Rule-based Row Filter3 %
- Excel Writer2 %
- Math Formula2 %
- Cell Splitter2 %
- Column Resorter2 %
- CSV Writer1 %
- Duplicate Row Filter1 %
- Constant Value Column1 %
- Missing Value1 %
Row Splitter (deprecated)1 %- Column Expressions1 %
- Reference Row Filter1 %
- Rule-based Row Splitter1 %
- Sorter< 1 %
- GET Request< 1 %
- Pivot< 1 %
- Loop End< 1 %
- String to Path< 1 %
- Table Row to Variable Loop Start< 1 %
- String Manipulation (Multi Column)< 1 %
- String Replacer< 1 %
- Cross Joiner< 1 %
- Column Appender< 1 %
- Column Combiner< 1 %
- Column Renamer< 1 %
- Table Manipulator< 1 %
- Chunk Loop Start< 1 %
- DB Writer< 1 %
Cell Replacer< 1 %- Number to String< 1 %
- RowID< 1 %
- Column Renamer (Dictionary)< 1 %
- Nominal Value Row Filter< 1 %
- Table Row to Variable< 1 %
- Group Loop Start< 1 %
- Value Lookup< 1 %
- Java Snippet< 1 %
Joiner< 1 %- POST Request< 1 %
- Reference Row Splitter< 1 %
- String to JSON< 1 %
- Date&Time to String< 1 %
- Table Transposer< 1 %
- Date&Time Part Extractor< 1 %
- Value Counter< 1 %
- Rule Engine (Dictionary)< 1 %
- DB Insert< 1 %
- Partitioning< 1 %
- End IF< 1 %
- Case Converter< 1 %
- Column Aggregator< 1 %
- String Splitter (Regex)< 1 %
- Date&Time Difference< 1 %
- Column Merger< 1 %
- Date&Time Shift< 1 %
- Date&Time-based Row Filter< 1 %
- String to URI< 1 %
- Table to JSON< 1 %
- Python Script (legacy)< 1 %
String To Number (PMML)< 1 %- Numeric Binner< 1 %
- Column Splitter< 1 %
- DB Update< 1 %
- Molecule Type Cast< 1 %
- Rank< 1 %
- Math Formula (Multi Column)< 1 %
- String to Date/Time (legacy)< 1 %
- Strings to Document< 1 %
- Missing Value Column Filter< 1 %
- Number Rounder< 1 %
- Cell Splitter By Position< 1 %
- Unpivot< 1 %
- Column to XML< 1 %
Scorer< 1 %- Statistics< 1 %
- Regex Extractor< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Column Comparator< 1 %
- Column Rename (Regex)< 1 %
- Similarity Search< 1 %
- Column Auto Type Cast< 1 %
- Nominal Value Row Splitter< 1 %
- HTTP Retriever< 1 %
- Row Filter (Labs)< 1 %
- CASE Switch End< 1 %
- Table Writer< 1 %
- Path to String< 1 %
- Color Manager< 1 %
- Joiner< 1 %
Linear Correlation< 1 %- Domain Calculator< 1 %
- Numeric Row Splitter< 1 %
- Create Collection Column< 1 %
- String to XML< 1 %
- IF Switch< 1 %
- Recursive Loop End< 1 %
- Add Empty Rows< 1 %
- String to Number (PMML)< 1 %
- Counter Generation< 1 %
- Loop End (Column Append)< 1 %
- Table Column to Variable< 1 %
- Normalizer< 1 %
- Table View< 1 %
- Row Sampling< 1 %
- Tableau Writer< 1 %
- String to Path (Variable)< 1 %
- String to Duration< 1 %
- Modify Date< 1 %
- String Replacer (Dictionary)< 1 %
- Ungroup< 1 %
- String Matcher< 1 %
- Value Selection Configuration< 1 %
- Webpage Retriever< 1 %
- Recursive Loop Start< 1 %
- Scorer< 1 %
- R Snippet< 1 %
- PUT Request< 1 %
- One to Many< 1 %
Database Looping< 1 %Tableau Writer (Hyper)< 1 %- Lag Column< 1 %
- Binary Objects to Files< 1 %
- Catch Errors (Data Ports)< 1 %
- Empty Table Switch< 1 %
- Java Snippet (simple)< 1 %
- Google Sheets Updater< 1 %
- Column Name Extractor< 1 %
- SDF Writer< 1 %
- DB Table Creator< 1 %
- JSON Writer< 1 %
- Column List Loop Start< 1 %
- Parquet Writer< 1 %
- JSON Row Combiner< 1 %
Loop End< 1 %- String Manipulation (Variable)< 1 %
- Tika Language Detector< 1 %
Hash Calculator< 1 %Table Row to Variable< 1 %String Replace (Dictionary)< 1 %- Parameterized DB Query Reader< 1 %
- Pie/Donut Chart (JavaScript)< 1 %
CSV Writer< 1 %Counting Loop Start< 1 %- Line Plot (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- URL to File Path< 1 %
Variable to Table Column< 1 %- Reference Column Filter< 1 %
- Row Aggregator< 1 %
- DB Loader< 1 %
- Columns to JSON< 1 %
- XPath< 1 %
- Table to HTML String< 1 %
- Latitude/Longitude to Coordinate< 1 %
- Numeric Scorer< 1 %
- One-way ANOVA< 1 %
- Conditional Box Plot (JavaScript)< 1 %
- String to Term< 1 %
- JSON Path< 1 %
List Files< 1 %Column Rename< 1 %- Rule-based Row Splitter (Dictionary)< 1 %
- Bar Chart (JavaScript)< 1 %
Send to Power BI< 1 %- Send to Tableau Server< 1 %
- JSON to Table< 1 %
- DELETE Request< 1 %
Table Row to Variable< 1 %- X-Partitioner< 1 %
- k-Means< 1 %
- Rank Correlation< 1 %
- DB Connector< 1 %
- DB Merge< 1 %
- Table Indexer< 1 %
- RDKit Descriptor Calculation< 1 %
- Copy/Move Files (legacy)< 1 %
Table Row To Variable Loop Start< 1 %- Category to Number< 1 %
Number To String (PMML)< 1 %- Modify Time< 1 %
- Statistics View< 1 %
- Excel Cell Updater< 1 %
- Scatter Plot (JavaScript)< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Normalize Plates (POC)< 1 %
- Linear Correlation< 1 %
- Stacked Area Chart< 1 %
- Parallel Chunk Start< 1 %
Table to PDF< 1 %- Excel Reader< 1 %
- Interactive Range Slider Filter Widget< 1 %
Web Searcher< 1 %- Advanced MolConverter< 1 %
Database Writer< 1 %- Generic Loop Start< 1 %
- Line Plot< 1 %
Table to HTML< 1 %- Tag Cloud< 1 %
Python Script (1⇒1)< 1 %- PubChem Search< 1 %
Database Update< 1 %Variable Condition Loop End< 1 %- PCA< 1 %
Random Forest Predictor< 1 %- Subset Matcher< 1 %
- OpenBabel< 1 %
- String Similarity< 1 %
- Variable to Table Column< 1 %
- Variable to Table Row< 1 %
Recursive Loop Start< 1 %- Linear Regression Learner< 1 %
- Auto-Binner< 1 %
- Scatter Plot< 1 %
Microsoft Authenticator (Deprecated)< 1 %- Container Output (Table)< 1 %
- JSON Transformer< 1 %
- MongoDB Connector< 1 %
- RDKit From Molecule< 1 %
- URL Encode< 1 %
- R Snippet (2:1)< 1 %
Cell Splitter< 1 %- Table Validator (Reference)< 1 %
- Reference Column Resorter< 1 %
- Send Email< 1 %
- Pie Chart< 1 %
- String Distances< 1 %
- Variable Expressions< 1 %
- Credentials Input (legacy)< 1 %
- JSON Path (Dictionary)< 1 %
- Python View (legacy)< 1 %
- Date Field Extractor (legacy)< 1 %
- Workflow Service Output< 1 %
- Try (Variable Ports)< 1 %
- Hierarchical Cluster View< 1 %
- Missing Value (Apply)< 1 %
- Table to Spark< 1 %
- DB Delete (Table)< 1 %
- Line Plot (Plotly)< 1 %
- Line Chart (JFreeChart)< 1 %
- Pie Chart (JFreeChart)< 1 %
- Bubble Chart (JFreeChart)< 1 %
- Create File/Folder Variables< 1 %
- PATCH Request< 1 %
- Modify Time Zone< 1 %
- Text Classifier Learner< 1 %
Regex Extractor< 1 %- Form Encoded HTTP Entity Creator< 1 %
- Table Creator< 1 %
- Constant Value Column Filter< 1 %
- Numeric Outliers< 1 %
- CASE Switch Start< 1 %
- Extract Table Dimension< 1 %
- Scatter Matrix (legacy)< 1 %
- Bar Chart (JFreeChart)< 1 %
- HeatMap (JFreeChart)< 1 %
Excel Writer (XLS)< 1 %Excel Writer (XLS)< 1 %- Spark Line Appender< 1 %
- Frequency Filter< 1 %
- POS Tagger< 1 %
- Table View (JavaScript)< 1 %
- Nominal Row Filter Widget< 1 %
- XGBoost Predictor< 1 %
OAuth< 1 %- Try (Data Ports)< 1 %
Table Reader< 1 %Interval Loop Start< 1 %- Variable Condition Loop End< 1 %
- K Nearest Neighbor< 1 %
- HiLite Row Splitter< 1 %
- Cache< 1 %
- Bar Chart< 1 %
Parquet Writer< 1 %Excel Sheet Appender (XLS)< 1 %- Send to Power BI< 1 %
- Bag Of Words Creator< 1 %
- List Files/Folders< 1 %
- String Configuration< 1 %
- Date&Time Input (legacy)< 1 %
- Column Selection (legacy)< 1 %
- Table to R< 1 %
- Table Difference Checker< 1 %
- Legacy Date&Time to Date&Time< 1 %
- N-Gram Extractor< 1 %
- Indigo Fingerprint< 1 %
- URL Decode< 1 %
- PDB Downloader< 1 %
- Expand Well Position< 1 %
- Regex Substring< 1 %
Variable to Table Column< 1 %Parameterized Database Query< 1 %Naive Bayes Learner< 1 %- Regression Predictor< 1 %
Random Forest Learner< 1 %String To Number< 1 %Column Appender< 1 %- Edit Nominal Domain (Dictionary)< 1 %
- Top k Row Filter< 1 %
- Box Plot< 1 %
- Microsoft SQL Server Connector< 1 %
- DB Query Reader< 1 %
- Violin Plot (Plotly)< 1 %
- Association Rule Learner (Borgelt)< 1 %
- Java Snippet Row Filter< 1 %
- Decompress Files< 1 %
- Path to URI< 1 %
- Google Sheets Reader< 1 %
- CSS Editor< 1 %
- Container Output (JSON)< 1 %
- Binary Classification Inspector< 1 %
- MongoDB Remove< 1 %
- Feature Inserter< 1 %
- Extract Duration Fields< 1 %
- Moving Average< 1 %
- Time to String (legacy)< 1 %
- RDKit Substructure Filter< 1 %
- Zero Shot Text Classifier< 1 %
- Date Extractor< 1 %
MapzenGeocoder< 1 %- Base64 Encoder< 1 %
HTTP Retriever< 1 %- XLS Cell Formatter< 1 %
- Canonical SMILES< 1 %
- Message Slack channel< 1 %
Open in Python< 1 %- String to Table< 1 %
- Split Collection Column< 1 %
- Inject Variables (Data)< 1 %
- Read Images< 1 %
Database SQL Executor< 1 %- CSV Reader< 1 %
- Variable Loop End< 1 %
- Decision Tree Learner< 1 %
- Create Bit Vector< 1 %
- Number to Category (Apply)< 1 %
- Filter Apply< 1 %
- Denormalizer< 1 %
- Number to String (PMML)< 1 %
- Row to Column Names< 1 %
- Set Operator< 1 %
- Table Cropper< 1 %
- Table Difference Finder< 1 %
- Rule Engine Variable< 1 %
- Ruleset Editor< 1 %
- Number Format Manager< 1 %
- Histogram< 1 %
Hive Loader (legacy)< 1 %- Capture Workflow End< 1 %
- Empty Table Creator< 1 %
- One Row to Many< 1 %
- SharePoint Online List Writer< 1 %
- Keygraph Keyword Extractor< 1 %
- Punctuation Erasure< 1 %
- Wildcard Tagger< 1 %
- Credentials Configuration< 1 %
- String Input (legacy)< 1 %
- Interactive Value Filter Widget< 1 %
- JSON to XML< 1 %
- MongoDB Writer< 1 %
Dumb Joiner< 1 %- Google Address Geocoder< 1 %
Map Viewer< 1 %- Coordinate Parser< 1 %
- URL Extractor< 1 %
- XLS Conditional Formatter< 1 %
- AutoDock Vina< 1 %
- Message Slack User< 1 %
- TIBCO Spotfire File Writer< 1 %
Loop End (Upto 6 ports)< 1 %- Outlier Removal< 1 %
- Plate Heatmap Viewer< 1 %
- MolConverter< 1 %
- ZXing Encoder< 1 %
- Regex To List< 1 %
Binary Objects to Files< 1 %- Breakpoint< 1 %
- Catch Errors (Var Ports)< 1 %
Table Column to Variable< 1 %CSV Reader< 1 %Table Row To Variable Loop Start< 1 %- Naive Bayes Learner< 1 %
- Fuzzy Rule Learner< 1 %
- Logistic Regression Predictor< 1 %
- Polynomial Regression Learner< 1 %
- Random Forest Learner (Regression)< 1 %
- Category to Number (Apply)< 1 %
- Many to One< 1 %
- Edit Numeric Domain< 1 %
- Low Variance Filter< 1 %
- Numeric Binner (PMML)< 1 %
- Timer Info< 1 %
- HiLite Table (legacy)< 1 %
- Amazon Comprehend (Key Phrases)< 1 %
- Amazon Redshift Connector< 1 %
- Oracle Connector< 1 %
DB Loader< 1 %DB Table Creator< 1 %Send to Tableau Server (Hyper)< 1 %- Topic Extractor (Parallel LDA)< 1 %
- Case Converter< 1 %
- Dictionary Replacer< 1 %
Wildcard tagger< 1 %- External Tool (Labs)< 1 %
- Transfer Files (Table)< 1 %
- Transform< 1 %
- Google Sheets Writer< 1 %
- Column Filter Configuration< 1 %
- Date&Time Configuration< 1 %
- Image Normalizer< 1 %
- SHAP Loop Start< 1 %
- Date&Time to legacy Date&Time< 1 %
- Create Date&Time Range< 1 %
- Extract Time Window (legacy)< 1 %
- BERT Classification Learner< 1 %
- Spacy Tokenizer< 1 %
- Map Viewer< 1 %
- URL Resolver< 1 %
Click< 1 %- Wait< 1 %
- CIR< 1 %
- XLS Control Table from Cell Range< 1 %
- Duplicate Remover< 1 %
- DB Insert Column Header< 1 %
Loop End (3 ports)< 1 %- Table Row To Variable Run-for-time Loop Start< 1 %
- Uniquify IDs< 1 %
- Benchmark End< 1 %
- PDB Loader< 1 %
- PDB Saver< 1 %
- Save File Locally< 1 %
- Create Well Position< 1 %
- Number Formatter< 1 %
- Dose Response (R)< 1 %
- Normalize Plates (NPI)< 1 %
- Write To Excel Template< 1 %
- XLS Coloured Writer< 1 %
- Extract URI Info< 1 %
- Zip Files (legacy)< 1 %
- Wait...< 1 %
Table Column to Variable< 1 %Database Delete< 1 %Database Connector< 1 %- Image Writer (Table)< 1 %
- Variable Creator< 1 %
Loop End (2 ports)< 1 %- Counting Loop Start< 1 %
Recursive Loop Start (2 ports)< 1 %- X-Aggregator< 1 %
PCA< 1 %- Logistic Regression Learner< 1 %
Regression Predictor< 1 %- PCA Compute< 1 %
- Random Forest Learner< 1 %
Concatenate (Optional in)< 1 %- Column to Grid< 1 %
- Double to Integer< 1 %
- Extract Missing Value Cause< 1 %
- Reference Column Splitter< 1 %
- Row Splitter (Labs)< 1 %
- Column Filter (PMML)< 1 %
- Target Shuffling< 1 %
- Renderer to Image< 1 %
- Single sample t-test< 1 %
CASE Switch Variable (End)< 1 %CASE Switch Data (Start)< 1 %- Create Temp Dir (legacy)< 1 %
- Merge Variables< 1 %
- Pie chart (legacy)< 1 %
- Box Plot (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
Color Appender< 1 %- Shape Manager< 1 %
- Interactive Table (legacy)< 1 %
- Sunburst Chart< 1 %
- SDF Stripper< 1 %
- DB Connection Closer< 1 %
- DB SQL Executor< 1 %
- DB Table Selector< 1 %
- Numeric Distances< 1 %
- Bubble Chart (Plotly)< 1 %
- Error Bars Plot (Plotly)< 1 %
- Sunburst Chart (JavaScript)< 1 %
- PMML Predictor< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- Histogram Chart (JFreeChart)< 1 %
- SMB Connector< 1 %
Tableau Writer (TDE)< 1 %- Word Vector Apply (legacy)< 1 %
- TF< 1 %
- N Chars Filter< 1 %
- RegEx Filter< 1 %
- Tag Filter< 1 %
- Dictionary Tagger< 1 %
- Document Vector< 1 %
- Tags to String< 1 %
- Path to String (Variable)< 1 %
- Map viewer< 1 %
- File Upload (legacy)< 1 %
- Slider Input (legacy)< 1 %
- Value Selection (legacy)< 1 %
- Scorer (JavaScript)< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- Lift Chart (JavaScript)< 1 %
- Integer Widget< 1 %
- Image to DataRow< 1 %
- Image Viewer< 1 %
- Object Inserter< 1 %
- R View (Table)< 1 %
- Data to Report (BIRT)< 1 %
- Duration to String< 1 %
Extract Date&Time Fields< 1 %- Moving Aggregator< 1 %
- StringCell To File< 1 %
- Remove Empty Rows< 1 %
- BERT Predictor< 1 %
- Neo4j Writer< 1 %
Spacy Tokenizer< 1 %- HTML Node to Text< 1 %
- HTTP Result Data Extractor< 1 %
- HTML Parser< 1 %
- Navigate< 1 %
- XLS Row and Column Sizer< 1 %
- XLS Control Table Generator< 1 %
- Simulate Market< 1 %
- Configurable End IF/CASE< 1 %
- Run Garbage Collector< 1 %
- Collection to String< 1 %
- Inject Column Properties< 1 %
- Plate Row Converter< 1 %
Expand Well Position< 1 %- Combine Columns by Header< 1 %
Python Snippet< 1 %- Python Plot< 1 %
- R Plot< 1 %
- Bemis-Murcko< 1 %
- Standardizer< 1 %
- Uni Reactor (By Input)< 1 %
- Write To Excel Template (deprecated)< 1 %
- Create Firefox Browser Instance< 1 %
- 2D/3D Scatterplot< 1 %
- URL to Audio< 1 %
- Binary Objects to PNGs< 1 %
- Binary Objects to Strings< 1 %
- Create Directory (legacy)< 1 %
- Download / Upload from List (legacy)< 1 %
- File Meta Info (legacy)< 1 %
- Strings to Binary Objects< 1 %
- URI to String< 1 %
- URL to File Path (Variable)< 1 %
- Create File Name (legacy)< 1 %
- Extract Variables (Data)< 1 %
Database Reader< 1 %- File Reader< 1 %
- Table Reader< 1 %
Table Writer< 1 %- Java Edit Variable< 1 %
- Feature Selection Loop Start (1:1)< 1 %
Generic Loop Start< 1 %Recursive Loop End (2 ports)< 1 %Recursive Loop End< 1 %- Cluster Assigner< 1 %
- Hierarchical Clustering< 1 %
- Decision Tree Predictor< 1 %
K Nearest Neighbor< 1 %- RProp MLP Learner< 1 %
- SMOTE< 1 %
- SVM Learner< 1 %
- Gradient Boosted Trees Learner (Regression)< 1 %
Gradient Boosted Trees Predictor< 1 %- Tree Ensemble Learner< 1 %
- Random Forest Predictor< 1 %
- Random Forest Predictor (Regression)< 1 %
- Binner (Dictionary)< 1 %
- Bootstrap Sampling< 1 %
Number To String< 1 %- String to SVG< 1 %
- Correlation Filter< 1 %
- Table Validator< 1 %
- CAIM Binner< 1 %
- Edit Nominal Domain< 1 %
Double To Int< 1 %- Equal Size Sampling< 1 %
Column Filter< 1 %- Filter Apply Row Splitter< 1 %
- Normalizer (PMML)< 1 %
- Nominal Probability Distribution Creator< 1 %
- Shuffle< 1 %
- Table Splitter< 1 %
- Rule Engine Variable (Dictionary)< 1 %
- Data Explorer< 1 %
- Independent groups t-test< 1 %
CASE Switch Data (End)< 1 %- Extract Table Spec< 1 %
- Conditional Box Plot (legacy)< 1 %
- Crosstab< 1 %
- Enrichment Plotter (legacy)< 1 %
- Histogram (legacy)< 1 %
- Interactive Histogram (legacy)< 1 %
- Interactive Pie chart (legacy)< 1 %
- Line Plot (legacy)< 1 %
- Density Plot< 1 %
- Heatmap< 1 %
- Hive Connector< 1 %
- Parquet Reader< 1 %
Parquet Writer< 1 %- Amazon S3 Connection (legacy)< 1 %
- Parallel Chunk End< 1 %
- MySQL Connector< 1 %
- PostgreSQL Connector< 1 %
- Snowflake Connector< 1 %
- DB Looping< 1 %
- DB Row Manipulator< 1 %
- Gaussian Distributed Assigner< 1 %
- Random Number Assigner< 1 %
- One Rule Inserter< 1 %
- Random Label Assigner< 1 %
- Random Boolean Assigner< 1 %
- Random Matcher< 1 %
- Distance Matrix Calculate< 1 %
- k-Medoids< 1 %
- Autocomplete Text Widget< 1 %
- Histogram (JavaScript)< 1 %
- Scatter Plot (Plotly)< 1 %
- Surface Plot (Plotly)< 1 %
- Table to HTML (legacy)< 1 %
- Table to PDF (legacy)< 1 %
- Generic Web Service Client< 1 %
- External Tool< 1 %
- Table to H2O< 1 %
- Math Formula (Variable)< 1 %
- JPython Script 1:1 (Legacy)< 1 %
- OSM Map View< 1 %
Excel Reader (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %- External SSH Tool< 1 %
- Java IF (Table)< 1 %
- Java Snippet Row Splitter< 1 %
- Radar Plot Appender< 1 %
- Doc2Vec Learner (legacy)< 1 %
- IDF< 1 %
- Markup Tag Filter< 1 %
- Tika Parser URL Input< 1 %
- Number Filter< 1 %
- Replacer< 1 %
- Snowball Stemmer< 1 %
- Stanford Lemmatizer< 1 %
- Stop Word Filter< 1 %
- Dictionary Tagger (Multi Column)< 1 %
- Oscar Tagger< 1 %
Document Data Extractor< 1 %- Document Data Extractor< 1 %
- Document Vector Hashing< 1 %
Strings To Document< 1 %- Term Neighborhood Extractor< 1 %
- Document Viewer< 1 %
- Delete Files/Folders< 1 %
- Create Folder< 1 %
- Files/Folders Meta Info< 1 %
- Create Temp Folder< 1 %
- GeoJSON writer< 1 %
- Shapefile writer< 1 %
Google Authenticator (API Key)< 1 %- Google Sheets Appender< 1 %
- Nominal Row Filter Configuration< 1 %
- Column Filter (legacy)< 1 %
- Value Filter (legacy)< 1 %
- Decision Tree View (JavaScript)< 1 %
- Heatmap (JavaScript)< 1 %
- ROC Curve (JavaScript)< 1 %
- Tag Cloud (JavaScript)< 1 %
- Tile View (JavaScript)< 1 %
- Column Filter Widget< 1 %
- Column Selection Widget< 1 %
- Value Selection Widget< 1 %
- JSON Column Combiner< 1 %
- XML to JSON< 1 %
- Gaussian Convolution< 1 %
- Data Row to Image< 1 %
- Image Cropper< 1 %
- Labeling to Image< 1 %
- Network Feature Extractor< 1 %
Python Script (1⇒1)< 1 %Python Script (2⇒1)< 1 %- Git Fetch< 1 %
- Duration to Number< 1 %
- Window Loop Start< 1 %
- Date/Time Shift (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- Call Workflow (Table Based)< 1 %
- XML Writer< 1 %
- Molecule to CDK< 1 %
- Molecular Properties< 1 %
- RDKit Canon SMILES< 1 %
- RDKit From InChI< 1 %
- RDKit Interactive Table< 1 %
- RDKit From IUPAC< 1 %
- RDKit Find Murcko Scaffolds< 1 %
- RDKit Substructure Counter< 1 %
- Anonymization< 1 %
- Text Classifier Predictor< 1 %
Location Extractor< 1 %- MapQuest Geocoder< 1 %
- Hash Calculator< 1 %
- URL Domain Extractor< 1 %
- Find Elements< 1 %
- Execute JavaScript< 1 %
- Send Keys< 1 %
- Start WebDriver< 1 %
- Substructure Matcher< 1 %
IF Switch (Flow Variable Value)< 1 %- Notched Boxplot (JFreechart)< 1 %
- Range Splitter< 1 %
- MarvinView< 1 %
- Download Files with Authentication< 1 %
- Download (legacy)< 1 %
- SSH Connection (legacy)< 1 %
Database Drop Table< 1 %- Simple Regression Tree Learner< 1 %
- Expand Bit Vector< 1 %
- Normalizer (Apply)< 1 %
Rank Correlation< 1 %- Parallel Coordinates (legacy)< 1 %
- Amazon Translate< 1 %
- Parallel Chunk End (multi port)< 1 %
K Nearest Neighbor (Distance Function)< 1 %- Keras Network Executor< 1 %
- Parallel Coordinates Plot (JavaScript)< 1 %
- Index Query< 1 %
XLS Writer< 1 %- NGram Creator< 1 %
- StanfordNLP NE Learner< 1 %
- Term to String< 1 %
- Term Vector< 1 %
- Column Selection Configuration< 1 %
Simple Table View (JavaScript)< 1 %- Date&Time Widget< 1 %
- String Widget< 1 %
JSON Writer< 1 %- Kafka Producer< 1 %
- Feature Calculator (BETA)< 1 %
- ImageJ Macro< 1 %
Python Script (2⇒2)< 1 %- Connectivity< 1 %
- Fingerprints< 1 %
- RDKit To InChI< 1 %
- RDKit To Molecule< 1 %
- URL Normalizer< 1 %
Find Elements< 1 %- Quit WebDriver< 1 %
- Duplicate Filter< 1 %
- XLS Font Formatter< 1 %
- Standardizer< 1 %
- TableToFile< 1 %
- Fingerprint to Counts List< 1 %
Flow Variable End IF< 1 %- Timed Loop End (1 port)< 1 %
- MMP Molecule Multi-cut Fragment (RDKit)< 1 %
- Benchmark Start< 1 %
- List To Set< 1 %
- Range Filter< 1 %
- Table to String< 1 %
- Variable to Credentials< 1 %
- Table to Image< 1 %
Database Table Creator< 1 %- PNN Learner (DDA)< 1 %
- Association Rule Learner< 1 %
- Interactive HiLite Collector< 1 %
Normalizer< 1 %- Size Manager< 1 %
- Workflow Executor< 1 %
- Mol2 Writer< 1 %
- DB Row Filter< 1 %
- Conditional Label Assigner< 1 %
- Quasirandom Sequence Generator (Apache)< 1 %
- Matrix Distance< 1 %
- Keras Input Layer< 1 %
- Stacked Area Chart (JavaScript)< 1 %
- DL4J Feedforward Learner (Classification) (legacy)< 1 %
- H2O MOJO Predictor (Regression)< 1 %
- Scatter Plot (JFreeChart)< 1 %
XLS Sheet Appender< 1 %- Term Co-Occurrence Counter< 1 %
- Dictionary Filter< 1 %
- Hyphenator< 1 %
- StanfordNLP NE Scorer< 1 %
- StanfordNLP NE Tagger< 1 %
Column Filter Configuration< 1 %Column Selection Configuration< 1 %- Range Slider Filter Definition (legacy)< 1 %
- Value Filter Definition (legacy)< 1 %
- List Box Input (legacy)< 1 %
- File Download Widget< 1 %
- Image Converter< 1 %
MongoDB Writer< 1 %- Multi Feature Inserter< 1 %
- Assign Partition< 1 %
- Python Edit Variable (legacy)< 1 %
- R Learner< 1 %
- Block Programmatically (Table)< 1 %
- Twitter Search< 1 %
Binary Scorer< 1 %- Substructure Search< 1 %
- RDKit Add Conformers< 1 %
- RDKit Open 3D Alignment< 1 %
- RDKit R-Group Decomposition (deprecated)< 1 %
- RDKit Salt Stripper< 1 %
- Synchronize< 1 %
- Sequence Convert< 1 %
- XLS Sheet Properties< 1 %
- Fingerprint Similarity< 1 %
- Fingerprint to String< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- Table Row To Variable Run-to-time Loop Start< 1 %
- Write Variables< 1 %
- Expand Barcode< 1 %
- Normalize Plates (Z-Score)< 1 %
- Z-Primes (PC x NC)< 1 %
- Python Snippet< 1 %
- MolExporter< 1 %
- Fingerprint Similarity< 1 %
- Virtual Screening Metrics< 1 %
- ARIMA Predictor< 1 %
- List Remote Files (legacy)< 1 %
- Upload (legacy)< 1 %
- URI to Port< 1 %
- Catch Errors (Generic Ports)< 1 %
Table Column to Variable< 1 %Variable to Table Row< 1 %Image Writer (Port)< 1 %Database Joiner< 1 %Database Table Selector< 1 %Extract Context Properties< 1 %- Image Writer (Port)< 1 %
- Model Writer< 1 %
Naive Bayes Predictor< 1 %- Silhouette Coefficient< 1 %
- Fuzzy c-Means< 1 %
- Decision Tree to Image< 1 %
- MDS< 1 %
PCA Apply< 1 %Gradient Boosted Trees Learner< 1 %Tree Ensemble Learner< 1 %One to Many< 1 %Domain Calculator< 1 %- Kolmogorov-Smirnov Test< 1 %
- Wilcoxon Signed-Rank< 1 %
SDF Writer< 1 %- Amazon Comprehend (Dominant Language)< 1 %
Microsoft SQL Server Connector< 1 %- SQLite Connector< 1 %
- DB Connection Extractor< 1 %
- Beta Distributed Assigner< 1 %
- Stresser< 1 %
- Java Distance< 1 %
- Keras Network Writer< 1 %
- Box Plot (JavaScript)< 1 %
DL4J Feedforward Learner (legacy)< 1 %- H2O MOJO Predictor (Autoencoder)< 1 %
Excel Reader (XLS)< 1 %Word Vector Learner (legacy)< 1 %- Category to Class< 1 %
- Chi-Square Keyword Extractor< 1 %
- Diacritic Remover< 1 %
Punctuation Erasure< 1 %Stop Word Filter< 1 %Dictionary tagger< 1 %- OpenNLP NE Tagger< 1 %
POS tagger< 1 %- Delete Files/Folders (Table)< 1 %
- Buffer< 1 %
- Google Analytics Query (legacy)< 1 %
Google Authenticator (Deprecated)< 1 %Google Sheets Interactive Service Provider< 1 %- Text Output Widget (legacy)< 1 %
- Container Output (Row)< 1 %
- JSON Reader< 1 %
- Labeling Filter< 1 %
- Apply Color Settings To Labels< 1 %
- Hierarchy Extractor< 1 %
- Network Viewer< 1 %
- Time Difference (legacy)< 1 %
- Time Generator (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
- Twitter Users< 1 %
Call Workflow Service< 1 %- XML Column Combiner< 1 %
- Sum Formula< 1 %
- RDKit Generate Coords< 1 %
- RDKit One Component Reaction< 1 %
- RDKit Fingerprint< 1 %
- RDKit Two Component Reaction< 1 %
- Hierarchical Anonymization< 1 %
- Neo4j Connection< 1 %
- Neo4j Reader< 1 %
- Geo Distances< 1 %
Send Keys< 1 %- Extract Text< 1 %
- Window Function< 1 %
- Network Component Splitter< 1 %
- XLS Background Colorizer< 1 %
- Reaxys Bioactivities< 1 %
- Component Separator< 1 %
- Dearomatizer< 1 %
- Hydrogen Remover< 1 %
- Generate 2D Coordinates< 1 %
- Molecule Properties< 1 %
- ICon< 1 %
- SDF Writer< 1 %
- Table Merger< 1 %
- Compiled Model Predictor< 1 %
- KNIME Server Connector< 1 %
- Feature Table To List< 1 %
- Message Slack channel (row based)< 1 %
- Speedy SMILES Chiral Centre Count< 1 %
- Speedy SMILES Strip Double Bond Geometry< 1 %
- Fingerprint From String< 1 %
- Fingerprint From Binary String< 1 %
- Fingerprint From Counts list< 1 %
- Type< 1 %
Flow Variable IF Switch< 1 %Flow Variable IF Switch (Flow Variable Value)< 1 %- Chunk Loop Run-to-time Loop Start< 1 %
- Generic Run-for-time Loop Start< 1 %
- Generic Run-to-time Loop Start< 1 %
- Timed Loop End (2 port)< 1 %
Wait-for-time< 1 %- MMP Molecule Fragment (RDKit)< 1 %
- Empty Collection to Missing< 1 %
- Missing to Empty Collection< 1 %
- Load text-based files< 1 %
- Trim Table< 1 %
- Coordinate Row Filter< 1 %
- Join Layout< 1 %
- Split Columns by Header< 1 %
- R Snippet< 1 %
- Spell Checker: Apply Rules< 1 %
- Spell Checker: Create Rules< 1 %
- Spell Checker (simple)< 1 %
- MolSearch< 1 %
- Uni Reactor< 1 %
- Chemical Search< 1 %
- Simple Search< 1 %
- ChemSpider< 1 %
- Upload Files with Authentication< 1 %
- Density Scorer< 1 %
Element Selector< 1 %- ARIMA Visualization< 1 %
- Acoustic Feature Extractor< 1 %
- Audio Viewer< 1 %
- Byte Vector Distances< 1 %
- Delete Files (legacy)< 1 %
File Meta Info< 1 %- Files to Binary Objects< 1 %
- PNGs to Binary Objects< 1 %
- Unzip Files (legacy)< 1 %
- Active Branch Inverter< 1 %
- Inject Variables (Database)< 1 %
Variable to Table Row< 1 %Image Writer (Table Column)< 1 %- ARFF Reader< 1 %
- ARFF Writer< 1 %
Database Connection Table Writer< 1 %Database Query< 1 %Database Table Connector< 1 %SQL Inject< 1 %File Reader< 1 %PMML Writer< 1 %Model Writer< 1 %- Feature Selection Filter< 1 %
- Feature Selection Loop Start (2:2)< 1 %
Loop End (Column Append)< 1 %Variable Loop End< 1 %- Naive Bayes Predictor< 1 %
- Fuzzy Rule Predictor< 1 %
- MultiLayerPerceptron Predictor< 1 %
PCA Compute< 1 %Logistic Regression Learner< 1 %Numeric Scorer< 1 %- SVM Predictor< 1 %
Simple Regression Tree Predictor< 1 %Gradient Boosted Trees Learner (Regression)< 1 %- Gradient Boosted Trees Predictor< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Tree Ensemble Predictor< 1 %
- Simple Regression Tree Predictor< 1 %
- Perl Scripting< 1 %
- Auto-Binner (Apply)< 1 %
- Create Byte Vector< 1 %
- Line Chopper< 1 %
Column Combiner< 1 %Missing Value< 1 %- One to Many (PMML)< 1 %
- Denormalizer (PMML)< 1 %
- XML to PMML< 1 %
- Nominal Probability Distribution Splitter< 1 %
- Ruleset Predictor< 1 %
- Cronbach Alpha< 1 %
- Kaplan-Meier Estimator< 1 %
- Wilcoxon-Mann-Whitney Test< 1 %
Merge Variables< 1 %- Lift Chart (legacy)< 1 %
- Size Appender< 1 %
- ROC Curve (legacy)< 1 %
- Save Workflow< 1 %
ORC Writer< 1 %MySQL Connector< 1 %- Microsoft Access Connector< 1 %
- DB Reader< 1 %
- DB GroupBy< 1 %
- DB Query Injector< 1 %
- Random Label Assigner (Data)< 1 %
- Random Number Assigner (Apache)< 1 %
- TimeDelay Loop End< 1 %
- TimeDelay Loop Start< 1 %
- Time Series Generator< 1 %
Distance Matrix Calculate< 1 %- Distance Matrix Writer< 1 %
DL Network Executor< 1 %- 2D Density Plot (Plotly)< 1 %
- 3D Scatter Plot (Plotly)< 1 %
- Radar Plot (Plotly)< 1 %
- Stacked Area Chart (Plotly)< 1 %
- Cell to Model< 1 %
- Cell to PMML< 1 %
- Explorer Browser< 1 %
- DL4J Feedforward Learner (Pretraining) (legacy)< 1 %
- Item Set Finder (Borgelt)< 1 %
- Ruby Script< 1 %
- JPython Function (Legacy)< 1 %
- JPython Script 2:1 (Legacy)< 1 %
- LIBSVMLearner< 1 %
- OSM Map to Image< 1 %
- Geo-Coordinate Row Filter< 1 %
TIBCO File Writer< 1 %Open TIBCO Spotfire< 1 %- Java Edit Variable (simple)< 1 %
Send to Tableau Server (TDE)< 1 %- Word2Vec Learner (legacy)< 1 %
- StanfordNLP Relation Extractor< 1 %
- Brat Document Writer< 1 %
- Dictionary Replacer (File-based)< 1 %
- Kuhlen Stemmer< 1 %
N Chars Filter< 1 %- Porter Stemmer< 1 %
POS Filter< 1 %- Tag Stripper< 1 %
- PDF Parser< 1 %
- RSS Feed Reader< 1 %
- Stanford Tagger< 1 %
Bag of Words Creator< 1 %- Document Data Assigner< 1 %
Meta Info Extractor< 1 %- Meta Info Inserter< 1 %
- Sentence Extractor< 1 %
- Unique Term Extractor< 1 %
Document Viewer< 1 %- Weka Predictor (3.7)< 1 %
- Compress Files/Folder (Table)< 1 %
- Transfer Files< 1 %
- Google Sheets Connector< 1 %
- Text Output (legacy)< 1 %
- Credentials Widget< 1 %
- Slider Widget< 1 %
JSON Reader< 1 %- JSON Schema Validator< 1 %
- PNG Image to ImgPlus< 1 %
- Labeling to RGB Img< 1 %
- Dimension Swapper< 1 %
- Image Properties< 1 %
- Global Thresholder< 1 %
- Fill Holes< 1 %
- Intensity Binner< 1 %
- Image Resizer< 1 %
- Connected Component Analysis< 1 %
- Image to Labeling< 1 %
- Labeling Arithmetic< 1 %
- Label Transformer< 1 %
- Don't Save Start< 1 %
- Add Noise...< 1 %
- Row to Network< 1 %
- Distance Matrix to Network< 1 %
- Feature Table< 1 %
- Matrix to Network< 1 %
- Multiobjective Subset Selection (NSGA-II)< 1 %
Python Script (2⇒1)< 1 %- Python Learner (legacy)< 1 %
- Python Object Reader (legacy)< 1 %
Python Script (1⇒2)< 1 %- Python Source (legacy)< 1 %
Column Selection QuickForm (legacy)< 1 %Value Filter QuickForm (legacy)< 1 %Value Selection QuickForm (legacy)< 1 %- Add Table to R< 1 %
- Create Git Tag< 1 %
- SPARQL Insert< 1 %
- Disturber Node< 1 %
- Create FileStore Column< 1 %
- Twitter Retweet Search< 1 %
- Twitter Post Tweet< 1 %
- Country Extractor< 1 %
XGBoost Tree Ensemble Learner< 1 %- XML Row Combine and Write< 1 %
XML Writer< 1 %- XSLT< 1 %
Table to HTML String< 1 %- Row Splitter (col+)< 1 %
- Result< 1 %
- Depiction< 1 %
- Fingerprint Similarity< 1 %
- Mass Calculator< 1 %
- RDKit Chemical Transformation< 1 %
- RDKit Kekulizer< 1 %
- RDKit Molecule Substructure Filter< 1 %
- Anonymity Assessment< 1 %
- Create Hierarchy< 1 %
- Information Gain Calculator< 1 %
- Web Page Content Extractor< 1 %
ReverseGeocoder< 1 %Column Distance< 1 %FreeGeoIP< 1 %- Multipart Encoded HTTP Entity Creator< 1 %
- WebDriver Factory< 1 %
Extract Outer/InnerHTML< 1 %Execute JavaScript< 1 %
Views
- This node has no views
Workflows
justknimeit-27KNIME Hub- _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
- Show all 7011 workflows
Links
- Adding Columnsby izaychik63 on 2018-11-27forum.knime.com/p/50441
- delete leading and trailing spaces in a rowby qqilihq on 2018-11-22forum.knime.com/p/50331
- Finding and replacing part of a stringby armingrudd on 2019-04-23forum.knime.com/p/59257
- Counting characters text processingby qqilihq on 2019-04-08forum.knime.com/p/58211
- trying to add a specific amont of characters to a cellby AnotherFraudUser on 2021-11-25forum.knime.com/p/140310
- Show all 57 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.