Icon

KNIME_​StringSplitReplace

Basic option - hand code the translationsof appendix to result columnThis is fine for small numbers of codes,without any "future proofing" Lookup table option -a table is used toprovide the translations of appendix toresult columnThis is more involved but better if yourtranslations may need to change in future,or if you have a large number oftranslations Sample Datapad the cost center id out to 8 characters, find the last two charactersand then strip the white spaceTranslate Appendix to ResultSample Datapad the cost center id out to 8 characters, find the last two charactersand then strip the white spaceAppendix lookup tableTranslate Resultbased on AppendixAdd row numberto enable latersorting back to original orderSort back to original orderRemove "counter"columnHandle MissingResult Excel Reader String Manipulation Rule Engine Excel Reader String Manipulation Table Creator Joiner Counter Generation Sorter Column Filter Rule Engine Basic option - hand code the translationsof appendix to result columnThis is fine for small numbers of codes,without any "future proofing" Lookup table option -a table is used toprovide the translations of appendix toresult columnThis is more involved but better if yourtranslations may need to change in future,or if you have a large number oftranslations Sample Datapad the cost center id out to 8 characters, find the last two charactersand then strip the white spaceTranslate Appendix to ResultSample Datapad the cost center id out to 8 characters, find the last two charactersand then strip the white spaceAppendix lookup tableTranslate Resultbased on AppendixAdd row numberto enable latersorting back to original orderSort back to original orderRemove "counter"columnHandle MissingResult Excel Reader String Manipulation Rule Engine Excel Reader String Manipulation Table Creator Joiner Counter Generation Sorter Column Filter Rule Engine

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-05
On NodePit since: 2022-02-06
Last update: 2024-11-21
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!