{"title":"String Cleaner","nodeType":"Manipulator","id":"*wsgqS8W_d8XAAxX-","factoryName":"org.knime.base.node.preproc.stringcleaner.StringCleanerNodeFactory","factoryId":"org.knime.base.node.preproc.stringcleaner.StringCleanerNodeFactory","path":["Manipulation","Column","Convert & Replace"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>The String Cleaner node provides tools for basic string cleaning operations like removing whitespace, removing punctuation or padding. For more complex string manipulation operations, the String Manipulation node should be used. All operations in this node are applied exactly in the order as they appear in the node dialog. The node is unicode-compatible. For reference on what characters are included in a category, see e.g. the Wikipedia guides to <a href=\"https://en.wikipedia.org/wiki/Unicode_character_property#General_Category\" rel=\"ugc nofollow noopener noreferrer\">Character categories</a> and <a href=\"https://en.wikipedia.org/wiki/Whitespace_character\" rel=\"ugc nofollow noopener noreferrer\">Whitespace</a> .</p>\n        ","shortDescription":"The String Cleaner provides tools for basic string cleaning","keywords":["Manipulation","Case","Whitespace","Pad","Punctuation","Character"],"deprecated":false,"streamable":true,"tags":["Manipulation","Column","Convert & Replace","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAwnpUWHRSYXcgcHJvZmlsZSB0eXBlIGV4aWYAAHjabVBbDgMhCPznFD0CArp4HLdrk96gxy8u2KxtJ3EcHhkR6K/nA24DlAQkb1pqKWiQKpWaCUVHOzmhnBwBTrHk4VMgS7Hd7KGW6J/5hItTaqbyxUjvUdjXQpXw1y8j8ovHREMfYVTDiMkLKQyafwtL1e36hb3jCvUDg0TXsX/izbZ3ZHuHiTonRmNm8QF4HAZuJurJxRoTZ9Nibc30nMQW8m9PE/AG1sBZDulvNPQAAAGFaUNDUElDQyBwcm9maWxlAAB4nH2RPUjDQBzFX1u1Ki0OdhBxyFDFwYKoiGOtQhEqhFqhVQeTSz+EJg1Jiouj4Fpw8GOx6uDirKuDqyAIfoC4ujgpukiJ/0sKLWI8OO7Hu3uPu3eAv15mqtkRB1TNMtLJhJDNrQjBV/SgC2GMYlxipj4riil4jq97+Ph6F+NZ3uf+HGElbzLAJxDHmW5YxOvE05uWznmfOMJKkkJ8Tjxm0AWJH7kuu/zGueiwn2dGjEx6jjhCLBTbWG5jVjJU4iniqKJqlO/Puqxw3uKslquseU/+wlBeW17iOs0hJLGARYgQIKOKDZRhIUarRoqJNO0nPPyDjl8kl0yuDTByzKMCFZLjB/+D392ahckJNymUADpfbPtjGAjuAo2abX8f23bjBAg8A1day1+pAzOfpNdaWvQI6NsGLq5bmrwHXO4AA0+6ZEiOFKDpLxSA9zP6phzQfwv0rrq9Nfdx+gBkqKvUDXBwCIwUKXvN493d7b39e6bZ3w+8uHLEfPzy8wAADXhpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+Cjx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IlhNUCBDb3JlIDQuNC4wLUV4aXYyIj4KIDxyZGY6UkRGIHhtbG5zOnJkZj0iaHR0cDovL3d3dy53My5vcmcvMTk5OS8wMi8yMi1yZGYtc3ludGF4LW5zIyI+CiAgPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIKICAgIHhtbG5zOnhtcE1NPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvbW0vIgogICAgeG1sbnM6c3RFdnQ9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZUV2ZW50IyIKICAgIHhtbG5zOmRjPSJodHRwOi8vcHVybC5vcmcvZGMvZWxlbWVudHMvMS4xLyIKICAgIHhtbG5zOkdJTVA9Imh0dHA6Ly93d3cuZ2ltcC5vcmcveG1wLyIKICAgIHhtbG5zOnRpZmY9Imh0dHA6Ly9ucy5hZG9iZS5jb20vdGlmZi8xLjAvIgogICAgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIgogICB4bXBNTTpEb2N1bWVudElEPSJnaW1wOmRvY2lkOmdpbXA6MWVhZGQ3ODEtODlkNy00ODcxLThiMTItMWQzODQ5OTQ2NDZmIgogICB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOmZlY2RkOTNhLTg4NjAtNGY5My1hZTVlLTVlNjI2ODFlOWE0MiIKICAgeG1wTU06T3JpZ2luYWxEb2N1bWVudElEPSJ4bXAuZGlkOjgwZDBkMWUxLWJhOTMtNDkzMS1hYWY5LTNiOTJhZmZmOTViZCIKICAgZGM6Rm9ybWF0PSJpbWFnZS9wbmciCiAgIEdJTVA6QVBJPSIyLjAiCiAgIEdJTVA6UGxhdGZvcm09IkxpbnV4IgogICBHSU1QOlRpbWVTdGFtcD0iMTY5NDAwNzc5NTYzNTA1NiIKICAgR0lNUDpWZXJzaW9uPSIyLjEwLjM0IgogICB0aWZmOk9yaWVudGF0aW9uPSIxIgogICB4bXA6Q3JlYXRvclRvb2w9IkdJTVAgMi4xMCIKICAgeG1wOk1ldGFkYXRhRGF0ZT0iMjAyMzowOTowNlQxNTo0MzoxNCswMjowMCIKICAgeG1wOk1vZGlmeURhdGU9IjIwMjM6MDk6MDZUMTU6NDM6MTQrMDI6MDAiPgogICA8eG1wTU06SGlzdG9yeT4KICAgIDxyZGY6U2VxPgogICAgIDxyZGY6bGkKICAgICAgc3RFdnQ6YWN0aW9uPSJzYXZlZCIKICAgICAgc3RFdnQ6Y2hhbmdlZD0iLyIKICAgICAgc3RFdnQ6aW5zdGFuY2VJRD0ieG1wLmlpZDowNWY1OWMxNC1hNWU2LTQ1NzAtOTUxMC05OWY3YzcyMThjZTEiCiAgICAgIHN0RXZ0OnNvZnR3YXJlQWdlbnQ9IkdpbXAgMi4xMCAoTGludXgpIgogICAgICBzdEV2dDp3aGVuPSIyMDIzLTA5LTA2VDE1OjQzOjE1KzAyOjAwIi8+CiAgICA8L3JkZjpTZXE+CiAgIDwveG1wTU06SGlzdG9yeT4KICA8L3JkZjpEZXNjcmlwdGlvbj4KIDwvcmRmOlJERj4KPC94OnhtcG1ldGE+CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAKPD94cGFja2V0IGVuZD0idyI/Pnd45coAAAAGYktHRAD/AP8A/6C9p5MAAAAJcEhZcwAACxMAAAsTAQCanBgAAAAHdElNRQfnCQYNKw8B+c+cAAAAuElEQVQ4y8WTzRGCMBBGn5ECLCElwM0blGAH0gF2IF14tgNLoAPTgXTgWAFevszs4IABD34zb5Ld/G02G5hWDTxFzUJVwADcxCBfslotihrk+5DjR/1/g0ytB47GX6o9j3zWvgJ9NHolagkPUrL87ZWymRDnVFrDrwg/4p2psALYJFJoTe6AXEZQvzHRHUTUSXMC8IqHB6CbKOHOjI2T3QH3LXDRM3rt6M2HqoCdqMx1vdjbU9fQvgH+I0zGnWD0bQAAAABJRU5ErkJggg==","sinceVersion":"5.2.0","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input table","description":"Input table containing string columns"}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Output table","description":"Output table with the selected columns modified"}],"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":"Columns to clean","description":"Select which columns should be cleaned. The strings in these columns will be modified according to the configuration of this node.","optional":false},{"name":"Remove accents and diacritics","description":"When enabled, all accents and diacritics are removed from letters, leaving only the underlying letter. For example, Å becomes A, ë becomes e and だ becomes た.","optional":false},{"name":"Remove non-ASCII characters","description":"When enabled, all non- <a href=\"https://en.wikipedia.org/wiki/ASCII\" rel=\"ugc nofollow noopener noreferrer\">ASCII</a> characters are removed from strings.","optional":false},{"name":"Remove non-printable characters","description":"When enabled, all non-printable characters like a tabulator or non-break space are removed from strings.","optional":false},{"name":"Remove letters","description":"Select whether and what category of letters should be removed from strings.\n<ul><li><b>None</b> removes no letters.</li><li><b>All</b> removes all letters from a string. This includes letters from any language / script.</li><li><b>Uppercase</b> removes all uppercase letters from a string.</li><li><b>Lowercase</b> removes all lowercase letters from a string.</li></ul>\nNote that this step happens before potentially changing the casing of the string.","optional":false},{"name":"Remove numbers","description":"When enabled, all numbers are removed from strings. This includes e.g. 3, Ⅴ or ₅.","optional":false},{"name":"Remove punctuation","description":"When enabled, all punctuation is removed from strings. This includes e.g. _, ( or !.","optional":false},{"name":"Remove symbols","description":"When enabled, all symbols are removed from strings. This includes e.g. €, &#61; or ♮.","optional":false},{"name":"Other characters to remove","description":"Here, custom characters can be defined that should be removed from strings. The characters are all interpreted literally and case-sensitive. Note that this step happens before potentially changing the casing of the string.","optional":false},{"name":"Remove all whitespace","description":"If enabled, all whitespace is removed. This includes normal space ( ), line breaks (\\r\\n), tabulators (\\t) and all other whitespace.","optional":false},{"name":"Remove leading whitespace","description":"If enabled, leading whitespace is removed, that is, all whitespace from the start of the string to the first non-whitespace character.","optional":false},{"name":"Remove trailing whitespace","description":"If enabled, trailing whitespace is removed, that is, all whitespace from the last non-whitespace character to the end of the string.","optional":false},{"name":"Remove duplicate whitespace","description":"If selected, all occurrences of two or more whitespace characters in a row are replaced by a single standard space.","optional":false},{"name":"Line breaks","description":"Select whether to remove line breaks or replace them with a standard space. If <b>Replace by space</b> is selected, \\r\\n is replaced by only a single space, not two.","optional":false},{"name":"Special whitespace","description":"Select whether to remove special whitespace or replace it with a standard space. Special whitespace is all whitespace that is not a standard space, \\r or \\n.","optional":false},{"name":"Change casing","description":"Define the casing of letters in the output string.\n<ul><li><b>None</b> makes no changes to the string.</li><li><b>Uppercase</b> converts all letters to uppercase.</li><li><b>Capitalize</b> first converts all letters to lowercase, then capitalizes according to the defined settings.</li><li><b>Lowercase</b> converts all letters to lowercase.</li></ul>","optional":false},{"name":"Capitalize after","description":"Define after which characters a character should be capitalized.\n<ul><li><b>Whitespace</b> capitalizes letters that follow immediately after a whitespace character</li><li><b>Non-Letters</b> capitalizes letters that follow any non-letter character.</li><li><b>Custom</b> lets the user decide on a set of characters after which letters should be capitalized</li></ul>","optional":false},{"name":"Capitalize after characters","description":"Here, custom characters can be defined after which characters should be capitalized. The characters are all interpreted literally.","optional":false},{"name":"Capitalize character at the start of the string","description":"If enabled, a letter at the start of the string is always capitalized.","optional":false},{"name":"Pad","description":"Define whether to pad a string if it doesn&#39;t have a certain minimum length.\n<ul><li><b>None</b> makes no change to the string.</li><li><b>Start</b> adds a fill character to the start of the string.</li><li><b>End</b> adds a fill character to the end of the string.</li></ul>","optional":false},{"name":"Minimum string length","description":"Define the minimum string length. If a string is shorter than this value, a pad will be added to make the string length equal to it.","optional":false},{"name":"Fill character","description":"Define the fill character that is used to pad the string.","optional":false},{"name":"Output columns","description":"Define whether to clean the strings in-place (i.e. replace the existing values) or append (a) new column(s).","optional":false},{"name":"Output column suffix","description":"Define a suffix that is appended to the column names of the input table.","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":[]}