Icon

KNIME_​abbreviate 3

Option 1 - with nodes, but depends on allthe variations as to whether this doeswhat is needed Option2 - This allows for variable numberof "elements", although I consider itcheating a little as I'm writing code. Option3 - Capitalize the individualdelimited words first , and then take thefirst 2 characters of each along with thepreceding hyphen extract can be extractedto Columns, which (after fixing missingvalues) can be combined to a string Option4 - Capitalize the individualdelimited words first , and then the first 2characters of each along with the hyphenextract them to a List, which can then beconverted to a String by Vernalis node Node 1Split cell on "-"Capitalize the first two charactersof each (puts them in Mixed case)Recombine usinghyphensSplit cell on "-"but this time turn it into aString arrayJust do everything else!;-)Tidy upNode 8Blank if missingCapitalize words delimited by HyphenCombine colsback to a stringExtract into partsbut keep the hypenNode 18Extract into partsbut keep the hypenJoin the elementsof each list Table Creator Cell Splitter String Manipulation(Multi Column) Column Combiner Cell Splitter Column Expressions Column Filter String Replacer Missing Value String Manipulation(Multi Column) Column Combiner Regex Extractor Missing Value Regex Extractor Collectionto String Option 1 - with nodes, but depends on allthe variations as to whether this doeswhat is needed Option2 - This allows for variable numberof "elements", although I consider itcheating a little as I'm writing code. Option3 - Capitalize the individualdelimited words first , and then take thefirst 2 characters of each along with thepreceding hyphen extract can be extractedto Columns, which (after fixing missingvalues) can be combined to a string Option4 - Capitalize the individualdelimited words first , and then the first 2characters of each along with the hyphenextract them to a List, which can then beconverted to a String by Vernalis node Node 1Split cell on "-"Capitalize the first two charactersof each (puts them in Mixed case)Recombine usinghyphensSplit cell on "-"but this time turn it into aString arrayJust do everything else!;-)Tidy upNode 8Blank if missingCapitalize words delimited by HyphenCombine colsback to a stringExtract into partsbut keep the hypenNode 18Extract into partsbut keep the hypenJoin the elementsof each listTable Creator Cell Splitter String Manipulation(Multi Column) Column Combiner Cell Splitter Column Expressions Column Filter String Replacer Missing Value String Manipulation(Multi Column) Column Combiner Regex Extractor Missing Value Regex Extractor Collectionto String

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: @takbb Brian Bates
Created at: 2021-05-14
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.3.2

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

Try NodePit Runner!