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

: Input port with the table to be formatted.

Output Ports

: Output port with the table contained numbers after modification

Popular Predecessors

Popular Successors

Views

This node has no views

Workflows

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.

Installation

To use this node in KNIME, install the extension KNIME HCS Tools from the below update site following our NodePit Product and Node Installation Guide:

v5.3

A zipped version of the software site can be downloaded here.

Plugin provider: Max Planck Institute of Molecular Cell Biology and Genetics (MPI-CBG)

Plugin version: 5.3.0.v202407011120

On NodePit since: 2024-07-11

Last update: 2024-11-15

KNIME versions: v5.3, v5.2, v5.1, v4.7, v4.6, v4.5, v4.4, v4.3, v4.2, v4.1, v4.0, v3.7, v3.6

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!