Icon

Modify strings to numbers based on formula

Modify some text strings based on a calculation.

Text strings starting with < and > should be converted to numerics, and the value calculated based on a formula defined in the forum post

Sample Datafrom forumderive values from< and > stringsstrings to lower portother to topconvert strings to Doublereattach columnscolumn orderback to originalsequenceget colum listDelimitedText Reader String Manipulation(Multi Column) Column Splitter String to Number Column Appender ReferenceColumn Resorter Extract Table Spec Sample Datafrom forumderive values from< and > stringsstrings to lower portother to topconvert strings to Doublereattach columnscolumn orderback to originalsequenceget colum listDelimitedText Reader String Manipulation(Multi Column) Column Splitter String to Number Column Appender ReferenceColumn Resorter Extract Table Spec

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: bbate
Created at: 2024-05-22
On NodePit since: 2024-05-22
Last update: 2024-09-16
Created with KNIME version: v5.2.3

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

Try NodePit Runner!