{"title":"String Splitter (Regex)","nodeType":"Manipulator","id":"*KUuLa8QggcD_9C01","factoryName":"org.knime.base.node.preproc.regexsplit.RegexSplitNodeFactory","factoryId":"org.knime.base.node.preproc.regexsplit.RegexSplitNodeFactory","path":["Manipulation","Column","Split & Combine"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"

This node splits the string content of a selected column into logical groups using regular expressions. A capturing group is usually identified by a pair of parentheses, whereby the pattern in such parentheses is a regular expression. Optionally, a group can be named. See Pattern for more information. For each input, the capture groups are the output values. Those can be appended to the table in different ways; by default, every group will correspond to one additional output column.

\n \n

A short introduction to groups and capturing is given in the Java API . Some examples are given below:

\n \n

Parsing Patent Numbers

\n \n

Patent identifiers such as "US5443036-X21" consisting of a (at most) two-letter country code ("US"), a patent number ("5443036") and possibly some application code ("X21"), which is separated by a dash or a space character, can be grouped by the expression ([A-Za-z]{1,2})([0-9]+)[ \\-]?(.*$) . Each of the parenthesized terms corresponds to the aforementioned properties. For named output columns, we can add group names to the pattern:

\n Named and unnamed groups can also be mixed in one pattern.\n\n \n \n

Strip File URLs

\n \n

This is particularly useful when this node is used to parse the file URL of a file reader node (the URL is exposed as a flow variable and then exported to a table using a Variable to Table node). The format of such URLs is similar to "file:c:\\some\\directory\\foo.csv". Using the pattern [A-Za-z]*:(.*[/\\\\])(?<filename>([^\\.]*)\\.(.*$)) generates four groups: The first group identifies the directory and is denoted by (.*[/\\\\]) . It consumes all characters until a final slash or backslash is encountered; in the example, this refers to "c:\\some\\directory\\". The second group represents the file name, whereby it encapsulates the third and fourth group. The third group ( ([^\\.]*) ) consumes all characters after the directory, which are not a dot '.' (which is "foo" in the above example). The pattern expects a single dot (final which is ignored) and finally the fourth group (.*$) , which reads until the end of the string and indicates the file suffix ('csv'). The groups for the above example are

  1. Group 1 : c:\\some\\directory
  2. Group filename : foo.csv
  3. Group 3 : foo
  4. Group 4 : csv
\n \n \n \n

Email Address Extraction

\n \n

Let's consider a scenario where you have a list of email addresses. Using the pattern (?<username>.+)@(?<domain>.+) , you can extract the username and domain from the addresses. The groups for the email address "john.doe@example.com" are:

\n \n \n \n \n ","shortDescription":"Splits an input string (column) into multiple groups according to a regular expression.","keywords":["Regex Split","Extract","Regex","Pattern","Group","Capture"],"deprecated":false,"streamable":true,"tags":["Manipulation","Column","Split & Combine","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3hpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6RDkyRTdCRjgxODM0MTFFNTgxM0FFMEQwQTc0Qzg5QTIiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6RDEzNzMyRDIxODM0MTFFNTgxM0FFMEQwQTc0Qzg5QTIiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpjZTBmYzg4ZC1kNjkyLTQ5NDEtOTZiOC03ODIxMjliYWZkYWIiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6MGIzNmFjOTctNWViYS00MGU3LTkxODktYmJlOGQ3ZDBmMjRlIi8+IDwvcmRmOkRlc2NyaXB0aW9uPiA8L3JkZjpSREY+IDwveDp4bXBtZXRhPiA8P3hwYWNrZXQgZW5kPSJyIj8+S6TK2QAAAI5JREFUeNqUU4ENgDAIGwuP+8iO2yOYKSxIGGATs5nQWgv09oJaEUS79Ln0qFAVH4EnMgBYNpQFWGQTHLFcICJp9CQw0E5+OfBceKEuB5PvUxElNP18tORcAoNfhvlSlMFlzuZZpcogYdRjIwImA0hDlA5ImJxNvY2L4JH0qGO2O+kunBYmG6DSL1RwCzAA0vlGF6FBecsAAAAASUVORK5CYII=","sinceVersion":"5.3.0","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Data Table","description":"Input table with string column to be split."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input with split columns","description":"Input table with additional column(s) and potentially duplicated rows representing the pattern groups.See "Output matched groups as" for more details."}],"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":"String column","description":"Choose the column containing the strings to split","optional":false},{"name":"Pattern","description":"Define a pattern according to which the input string will be split. The capture groups that are defined in this pattern will correspond to the output values. A group can be defined in one of two ways:\n\nIf you want to use non-capturing groups, construct them with (?:pattern)","optional":false},{"name":"Case sensitive","description":"Specifies whether matching will distinguish between upper and lower case letters.\n
\nBy default, case-insensitive matching assumes that only characters in the US-ASCII charset are being matched. Unicode-aware case-insensitive matching can be enabled by enabling Unicode-aware case folding .\n
\nMatching case-insensitive may impose a slight performance penalty.","optional":false},{"name":"Require whole string to match","description":"If enabled, the provided pattern must match the whole string in order to return any results. Otherwise, the first match in the input string is used.","optional":false},{"name":"If pattern does not match","description":"Define what to do if a pattern can't be matched to the input string:\n","optional":false},{"name":"Enable Unix lines mode","description":"In this mode, only the '\\n' line terminator is recognized in the behavior of ., ^, and $.","optional":false},{"name":"Enable multiline mode (^ and $ match at the beginning / end of a line)","description":"In multiline mode the expressions ^ and $ match just after or just before, respectively, a line terminator or the end of the input sequence. By default these expressions only match at the beginning and the end of the entire input sequence.","optional":false},{"name":"Enable dotall mode (Dot . also matches newline characters)","description":"In dotall mode, the expression . matches any character, including a line terminator. By default this expression does not match line terminators.","optional":false},{"name":"Enable Unicode-aware case folding","description":"When this is enabled then case-insensitive matching, when enabled, is done in a manner consistent with the Unicode Standard. By default, case-insensitive matching assumes that only characters in the US-ASCII charset are being matched.\n
\nEnabling this may impose a performance penalty.","optional":false},{"name":"Enable canonical equivalence","description":"When enabled, two characters will be considered to match if, and only if, their full canonical decompositions match. The expression "a\\u030A", for example, will match the string "\\u00E5" when this is enabled. By default, matching does not take canonical equivalence into account.","optional":false},{"name":"Enable Unicode character classes","description":"When enabled, the (US-ASCII only) Predefined character classes and POSIX character classes are in conformance with the Unicode Standard.\n
\nEnabling this may impose a performance penalty.","optional":false},{"name":"Start group index counting from zero","description":"If enabled, the indices of non-named capturing groups start at zero instead of one. This setting is not meant to be manually enabled, but exists solely for the purpose of backwards-compatibility. Earlier versions of this node have this enabled to reflect how the node used to behave.","optional":false},{"name":"Output matched groups as","description":"Define how to output the results:\n","optional":false},{"name":"Output column prefix","description":"Define what prefix should be used for the output column names:\n","optional":false},{"name":"Custom prefix","description":"Define a custom column prefix.","optional":false},{"name":"Output column","description":"Choose whether to append the output column or replace the input column.","optional":false},{"name":"Output column name","description":"Choose a name for the output column","optional":false},{"name":"Group labels in output","description":"Define the naming of the output groups:\n\nThe impact of this setting depends on the selected Output mode :\n","optional":false},{"name":"Remove input column","description":"Remove the input column from the output 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":[{"id":"*PHWv6FsABEjrSc76","factoryName":"org.knime.base.node.preproc.rename.RenameNodeFactory","probability":0.1395045632333768},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.09778357235984354},{"id":"*eOn8ibZnxIkY7XhT","factoryName":"org.knime.base.node.preproc.stringmanipulation.StringManipulationNodeFactory","probability":0.07953063885267275},{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.048239895697522815},{"id":"*KUuLa8QggcD_9C01","factoryName":"org.knime.base.node.preproc.regexsplit.RegexSplitNodeFactory","probability":0.04563233376792699},{"id":"*jd2U-FYTI8jCbQls","factoryName":"org.knime.base.node.preproc.filter.row.RowFilterNodeFactory","probability":0.04432855280312908},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.04041720990873533},{"id":"*C-nR3bKHp4paQHZK","factoryName":"org.knime.base.node.preproc.filter.row.RowFilter2PortNodeFactory","probability":0.03129074315514994},{"id":"*20rIDLuYXD4U8cnN","factoryName":"org.knime.base.node.preproc.colconvert.stringtonumber.StringToNumberNodeFactory","probability":0.03129074315514994},{"id":"*IPAOkJNeJy0B8rPZ","factoryName":"org.knime.base.node.preproc.cellsplit.CellSplitterNodeFactory","probability":0.024771838331160364}]}