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