This node needs one column with the numbers that need to be modified. The node will create a new sortable string column or replace existing one with the formatted numbers so all of them have a constant number of digits.
| Number | Number Formatted |
|---|---|
| 2 | 02.00 |
| 10.5 | 10.50 |
| 3.33 | 03.33 |
| Leading character | Number Formatted |
|---|---|
| 0 | 02.00 |
| "empty space" | 2.00 |
| _ | _2.00 |
Options
Popular Predecessors
Number To String8 %Extract Date&Time Fields6 %String To Number6 %- Number Formatter5 %
CSV Reader5 %Joiner3 %- GroupBy2 %
Excel Reader (XLS)2 %- Concatenate2 %
- String to Number2 %
- Joiner2 %
Column Rename2 %- Sorter2 %
- String Manipulation2 %
- Math Formula2 %
- Create Interval2 %
- Column Resorter1 %
- Column Filter1 %
Row Filter (deprecated)1 %- String Splitter (Regex)1 %
- Number Rounder1 %
- Rule-based Row Filter1 %
- Rule Engine1 %
- Counter Generation1 %
- Number to String1 %
- Pivot1 %
- String Replacer1 %
Excel Reader (XLS)1 %- String to Date&Time1 %
- Cross Joiner1 %
- Column Rename (Regex)1 %
- Reference Column Filter1 %
- Excel Reader1 %
- Join Layout< 1 %
- Normalizer< 1 %
- RowID< 1 %
- Example Data< 1 %
- Nominal Value Row Splitter< 1 %
- Table Manipulator< 1 %
File Reader< 1 %Counting Loop Start< 1 %Concatenate (Optional in)< 1 %- Column Merger< 1 %
- Double to Integer< 1 %
- Reference Row Filter< 1 %
- String Manipulation (Variable)< 1 %
- Number Filter< 1 %
- RDKit From Molecule< 1 %
- Column Splitter< 1 %
- Column Expressions (legacy)< 1 %
- Cell Splitter By Position< 1 %
- Table Transposer< 1 %
Expand Well Position< 1 %- Load Layout< 1 %
Database Reader< 1 %- Table Creator< 1 %
Loop End< 1 %- Column Combiner< 1 %
- Category to Number< 1 %
- Constant Value Column< 1 %
- Missing Value< 1 %
String To Number (PMML)< 1 %- Unpivot< 1 %
- Statistics< 1 %
- Color Manager< 1 %
- Random Number Assigner< 1 %
Excel Reader (XLS)< 1 %- Date Field Extractor (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- Time to String (legacy)< 1 %
- Outlier Removal< 1 %
Table Column to Variable< 1 %Table Row To Variable Loop Start< 1 %- Column List Loop Start< 1 %
Cell Splitter< 1 %- Cell Splitter< 1 %
- Column Auto Type Cast< 1 %
Row Splitter (deprecated)< 1 %- Normalizer (Apply)< 1 %
Number To String (PMML)< 1 %- Number to String (PMML)< 1 %
- String to Number (PMML)< 1 %
- Ungroup< 1 %
- SDF Extractor< 1 %
- N Chars Filter< 1 %
- Term to String< 1 %
- Date&Time-based Row Filter< 1 %
- Discretise< 1 %
- Loop End< 1 %
- SDF Reader< 1 %
Python Script (1⇒1)< 1 %- Duration to Number< 1 %
Views
- This node has no views
Workflows
05_Dose_ResponseKNIME Hub- Chartschenko_et_al_RNAi_Live_Data_analysisKNIME Hub
- Data Cleanse 3KNIME Hub
- Data Cleanse 3KNIME Hub
- Data Cleanse 3KNIME Hub
- Show all 11 workflows
Links
- No links available
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.