{"title":"String Replacer (Dictionary)","nodeType":"Manipulator","id":"*yEWV69hLfijLvmTJ","factoryName":"org.knime.base.node.preproc.stringreplacer.dict2.StringReplacerDictNodeFactory","factoryId":"org.knime.base.node.preproc.stringreplacer.dict2.StringReplacerDictNodeFactory","path":["Manipulation","Column","Convert & Replace"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node replaces strings in selected columns. The dictionary table provides the patterns to search for and the values to replace matches with. If no pattern matches, the result string equals the input string. You can choose to modify strings in-place or add the result strings in new columns.</p>\n        ","shortDescription":"Uses a dictionary table to look up patterns and replacements and modifies strings accordingly.","keywords":["Dictionary","String","Substitute","Find","Replace","Regular Expression","RegEx","Wildcard"],"deprecated":false,"streamable":true,"tags":["Manipulation","Column","Convert & Replace","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAIAAACQkWg2AAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6ODBFMzhENjk4OUZCMTFFNTkyQzJBQjlCNTFCMUUyMzIiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6ODBFMzhENjg4OUZCMTFFNTkyQzJBQjlCNTFCMUUyMzIiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDo2MkQ2ODhCNTE4MzQxMUU1ODEzQUUwRDBBNzRDODlBMiIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDo2MkQ2ODhCNjE4MzQxMUU1ODEzQUUwRDBBNzRDODlBMiIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PugKRQAAAACcSURBVHjaYmBABSwsLHi4QMAIxP///4fzBQQEPnz4gMx91KID5/LnHmViIBHg1MDIyEiaBogednZ2ZBFmZmZ0Db9//0bmfv78uX3bIziXm5ubBdMByOzv3793bH8MZFR6yRF2Ej4//IcBfn5+CAOuosJTFm48UTYgq/716xc+Dcj2QMCPHz+YiFdNlJOAXiJNA8k2EAYEkzdAgAEAMR01JVmQ6RUAAAAASUVORK5CYII=","sinceVersion":"5.1.0","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Data Table","description":"The data table contains the string columns to perform the replacement on."},{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Dictionary Table","description":"The dictionary table has a pattern column and a replacement column that will be used to perform the replacements"}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Data Table with updated columns","description":"The dictionary table has a pattern column that defines what to search for and a replacement column that defines what to replace matches with."}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Target columns","description":"Select the columns in which the strings should be replaced.","optional":false},{"name":"Pattern type","description":"Select the type of pattern which you want to use.\n<ul><li><i>Literal</i> matches the pattern as is.</li><li><i>Wildcard</i> matches <tt>*</tt> to zero or more arbitrary characters and matches <tt>?</tt> to any single character.</li><li><i>Regular expression</i> matches using the full functionality of Java regular expressions, including back references in the replacement text. See the <a href=\"http://docs.oracle.com/javase/6/docs/api/java/util/regex/Pattern.html\" rel=\"ugc nofollow noopener noreferrer\">Java API </a> for details.</li></ul>","optional":false},{"name":"Use backslash as escape character","description":"If checked, the backslash character can be used to escape special characters. For instance, <tt>\\?</tt> will match the literal character <tt>?</tt> instead of an arbitrary character. In order to match a backslash you need to escape the backslash, too ( <tt>\\</tt> ).","optional":false},{"name":"Case sensitive","description":"Specifies whether matching will distinguish between upper and lower case letters.","optional":false},{"name":"Pattern column","description":"The column containing literal strings, wildcard patterns or regular expressions, depending on the pattern type selected above.","optional":false},{"name":"Replacement column","description":"The column containing text that replaces the previous value in the cell if the pattern matched it. If you are using regular expressions, you may also use backreferences (e.g. <tt>$1</tt> to refer to the first capture group, named capture groups can also be used with <tt>(?&lt;group&gt;)</tt> and <tt>${group}</tt> to refer to them).","optional":false},{"name":"Replacement strategy","description":"Select what to replace in case a string matches a pattern.\n<ul><li><i>Whole string</i> replaces the entire string with the replacement string, requiring an exact match of the whole string.</li><li><i>All occurrences</i> replaces all occurrences of the pattern with the replacement string. Note that when e.g. matching on the RegEx-pattern <tt>.*</tt> , an empty string at the end of the input is also matched and replaced. To avoid that, use e.g. the pattern <tt>^.*</tt> to indicate that the match has to start at the beginning of the string.</li></ul>","optional":false},{"name":"If multiple patterns match","description":"Select the strategy to use if multiple patterns match.\n<ul><li><i>Apply first matching</i> only applies the first replacement that has a matching pattern.</li><li><i>Apply all sequentially</i> applies all replacements with matching patterns from the dictionary table sequentially. This means that later patterns can also match the output of another replacement: For example, when the input is &#34;A&#34; and there are the replacements A -&gt; B and B -&gt; C, the resulting string is &#34;C&#34;.</li></ul>","optional":false},{"name":"Append new columns","description":"If enabled, the strings will not be replaced in-place but new columns are appended that contains the original string with the replacement applied.","optional":false},{"name":"Suffix for new columns","description":"The suffix that is appended to the newly created columns with strings","optional":false}]}],"links":[],"kudos":[{"accountId":"account:user:0c03c943-d085-42be-a145-964bcd9d3525","user":"pravin","date":"2025-04-03T05:23:06+00:00"}],"kudosCount":1,"bundleInformation":{"bundleVersion":"5.12.0.v202606261225","bundleName":"KNIME Base Nodes","bundleSymbolicName":"org.knime.base","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.base","featureName":"KNIME Base nodes","featureVersion":"5.12.0.v202606261225","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*bjR3r1yWOznPIEXS"},"frequentSuccessors":[]}