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

Popular Successors

  • Number To String9 %
  • String To Number5 %
  • CSV Writer3 %
  • Row Splitter3 %
  • Missing Value3 %
  • Number Formatter2 %
  • Java Snippet2 %
  • Loop End2 %
  • Pivoting2 %
  • Range Filter2 %
  • Number To Category (Apply)2 %
  • Column Appender2 %
  • Column Filter2 %
  • Column Rename2 %
  • CSV Writer2 %
  • Column Resorter2 %
  • GroupBy2 %
  • Rule Engine2 %
  • Send Email2 %
  • Loop End1 %
  • Cell Splitter1 %
  • Column Combiner1 %
  • Number To String1 %
  • String To Number1 %
  • Row Filter1 %
  • Joiner1 %
  • Sorter1 %
  • Column Splitter1 %
  • String Manipulation1 %
  • End IF1 %
  • Bar Chart1 %
  • Math Formula1 %
  • Excel Writer1 %
  • RowID1 %
  • Rule-based Row Filter1 %
  • Math Formula (Multi Column)1 %
  • R View (Table)1 %
  • SDF Writer< 1 %
  • Column Expressions< 1 %
  • Geo-Coordinate Row Filter< 1 %
  • Excel Sheet Appender (XLS)< 1 %
  • GeneralizedSequentialPatterns (3.7)< 1 %
  • Python Script (1⇒1)< 1 %
  • Split Interval< 1 %
  • Group Loop Start< 1 %
  • Scorer< 1 %
  • Column Aggregator< 1 %
  • Insert Column Header< 1 %
  • Constant Value Column< 1 %
  • Edit Nominal Domain< 1 %
  • Duplicate Row Filter< 1 %
  • Statistics< 1 %
  • Extract Table Spec< 1 %
  • Color Manager< 1 %
  • Interactive Table< 1 %
  • Component Output< 1 %
  • Bar Chart (JavaScript)< 1 %
  • XLS Writer< 1 %
  • Excel Writer (XLS) (deprecated)< 1 %
  • Number Filter< 1 %
  • Table View< 1 %
  • JavaScript Line Plot< 1 %
  • Regex Extractor< 1 %
  • XLS Cell Formatter< 1 %
  • Data to Report< 1 %
  • Lookup and Add Columns< 1 %
  • Split Columns by Header< 1 %
  • Dose Response (R)< 1 %
  • Vector Length Normalization< 1 %
  • Plate Heatmap Viewer< 1 %
  • Groovy Script< 1 %
  • Python Snippet< 1 %
  • R Plot< 1 %
  • Loop End (Column Append)< 1 %
  • Chunk Loop Start< 1 %
  • PNN Learner (DDA)< 1 %
  • Logistic Regression Learner< 1 %
  • Random Forest Learner< 1 %
  • Concatenate< 1 %
  • Concatenate (Optional in)< 1 %
  • Cell Replacer< 1 %
  • Cell Splitter By Position< 1 %
  • Column Auto Type Cast< 1 %
  • Column Combiner (deprecated)< 1 %
  • Category To Number (Apply)< 1 %
  • Column Appender< 1 %
  • Column Merger< 1 %
  • Missing Value Column Filter< 1 %
  • Nominal Value Row Filter< 1 %
  • Joiner (deprecated)< 1 %
  • Partitioning< 1 %
  • Round Double< 1 %
  • String Replacer< 1 %
  • Top k Selector< 1 %
  • Transpose< 1 %
  • Unpivoting< 1 %
  • WrappedNode Input< 1 %
  • DB Row Filter< 1 %
  • Counter Generation< 1 %
  • Conditional Box Plot< 1 %
  • Pie/Donut Chart< 1 %
  • Radar Plot (Plotly)< 1 %
  • Sunburst Chart (JavaScript)< 1 %
  • Table to PDF< 1 %
  • Line Chart (JFreeChart)< 1 %
  • Scatter Plot (JFreeChart)< 1 %
  • Excel Writer (XLS)< 1 %
  • Java Snippet (simple)< 1 %
  • Case converter< 1 %
  • Replacer< 1 %
  • RandomForest (3.7)< 1 %
  • JSON To XML< 1 %
  • Python Script< 1 %
  • Python View< 1 %
  • Value Filter QuickForm (legacy)< 1 %
  • String to Date&Time< 1 %
  • Modify Date< 1 %

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.