{"title":"String Replacer","nodeType":"Manipulator","id":"*kg6wiYxLaACvn7qm","factoryName":"org.knime.base.node.preproc.stringreplacer.StringReplacerNodeFactory","factoryId":"org.knime.base.node.preproc.stringreplacer.StringReplacerNodeFactory","path":["Manipulation","Column","Convert & Replace"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node replaces strings in a selected target column. In the configuration dialog, a pattern and a replacement text are specified. If the pattern doesn&#39;t match, the result string equals the input string. You can choose to modify strings in-place or add the result strings to a new column.</p>\n        ","shortDescription":"Replaces strings if they match a certain pattern.","keywords":["RegEx","Find replace"],"deprecated":false,"streamable":true,"tags":["Manipulation","Column","Convert & Replace","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAIAAACQkWg2AAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6ODBFMzhENjU4OUZCMTFFNTkyQzJBQjlCNTFCMUUyMzIiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6ODBFMzhENjQ4OUZCMTFFNTkyQzJBQjlCNTFCMUUyMzIiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDo2MkQ2ODhCMTE4MzQxMUU1ODEzQUUwRDBBNzRDODlBMiIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDo2MkQ2ODhCMjE4MzQxMUU1ODEzQUUwRDBBNzRDODlBMiIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PuW8/yMAAACcSURBVHjaYmBABSwsLHi4QMAIxP///4fzBQQEPnz4gMx91KID5/LnHmViIBHg1MDIyEiaBogednZ2ZBFmZmZ0Db9//0bmfv78uX3bIziXm5ubBdMByOzv3793bH8MZFR6yRF2Ej4//IcBfn5+CAOuosJTFm48UTYgq/716xc+Dcj2QMCPHz+YiFdNlJOAXiJNA8k2EAYEkzdAgAEAMR01JVmQ6RUAAAAASUVORK5CYII=","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input","description":"The input table contains the string column to perform the replacement on."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input with replaced strings","description":"Input table with updated string column or an additional column."}],"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 column","description":"Select the column 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","description":"A literal string, wildcard pattern or regular expression, depending on the pattern type selected above.","optional":false},{"name":"Replacement text","description":"The text that replaces the previous value in the cell if the pattern matched it. If you are using a regular expression, 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":"Append new column","description":"If enabled, the strings will not be replaced in-place but a new column is appended that contains the original string with the replacement applied.","optional":false},{"name":"New column name","description":"The name of the created column with replaced strings","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"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":[{"id":"*kg6wiYxLaACvn7qm","factoryName":"org.knime.base.node.preproc.stringreplacer.StringReplacerNodeFactory","probability":0.16129032258064516},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.06955645161290322},{"id":"*eOn8ibZnxIkY7XhT","factoryName":"org.knime.base.node.preproc.stringmanipulation.StringManipulationNodeFactory","probability":0.06123991935483871},{"id":"*20rIDLuYXD4U8cnN","factoryName":"org.knime.base.node.preproc.colconvert.stringtonumber.StringToNumberNodeFactory","probability":0.055443548387096774},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.046370967741935484},{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.041834677419354836},{"id":"*jd2U-FYTI8jCbQls","factoryName":"org.knime.base.node.preproc.filter.row.RowFilterNodeFactory","probability":0.03528225806451613},{"id":"*IPAOkJNeJy0B8rPZ","factoryName":"org.knime.base.node.preproc.cellsplit.CellSplitterNodeFactory","probability":0.029233870967741934},{"id":"*0rhLXWO6OS1xMi8T","factoryName":"org.knime.base.node.preproc.append.row.AppendedRowsNodeFactory","probability":0.026461693548387098},{"id":"*Oy714gpoifm4PiOZ","factoryName":"org.knime.base.node.io.csvwriter.CSVWriterNodeFactory","probability":0.021925403225806453}]}