Number Formatter

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
The leading character can be chosen:
Leading character Number Formatted
0 02.00
"empty space" 2.00
_ _2.00
Node works only on positive numbers.

Options

Select a column
Choose a column to be formatted
Delete the Source Column
Choose this if you want to dismiss the source columns
Choose the leading character
Choose what kind of character should appear as a leading: "0", "empty space" or "_"

Input Ports

Icon
Input port with the table to be formatted.

Output Ports

Icon
Output port with the table contained numbers after modification

Popular Predecessors

  • Number To String7 %
  • Math Formula7 %
  • Extract Date&Time Fields6 %
  • String To Number5 %
  • CSV Reader5 %
  • Joiner3 %
  • Number Formatter2 %
  • Column Filter2 %
  • Excel Reader (XLS)2 %
  • Joiner2 %
  • Column Resorter2 %
  • GroupBy2 %
  • Column Rename2 %
  • Sorter2 %
  • String Manipulation2 %
  • Create Interval2 %
  • CSV Reader2 %
  • Row Filter1 %
  • Regex Split1 %
  • Round Double1 %
  • Rule-based Row Filter1 %
  • Rule Engine1 %
  • Counter Generation1 %
  • Concatenate1 %
  • Number To String1 %
  • String To Number1 %
  • Pivoting1 %
  • String Replacer1 %
  • Column Expressions1 %
  • 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 Int< 1 %
  • Reference Row Filter< 1 %
  • String Manipulation (Variable)< 1 %
  • Number Filter< 1 %
  • RDKit From Molecule< 1 %
  • Column Splitter< 1 %
  • Substructure Frequencies< 1 %
  • Cell Splitter By Position< 1 %
  • Transpose< 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 %
  • Unpivoting< 1 %
  • Statistics< 1 %
  • Color Manager< 1 %
  • Random Number Assigner< 1 %
  • Excel Reader (XLS)< 1 %
  • Date Field Extractor (legacy)< 1 %
  • String to Date/Time< 1 %
  • Time to String< 1 %
  • XLS Reader< 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< 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 %

Popular Successors

Views

This node has no views

Workflows

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.