{"title":"Cell Splitter By Position","nodeType":"Manipulator","id":"*m1bkjcKm-b81Pkl6","factoryName":"org.knime.base.node.preproc.cellsplitbypos.CellSplitterByPosNodeFactory","factoryId":"org.knime.base.node.preproc.cellsplitbypos.CellSplitterByPosNodeFactory","path":["Manipulation","Column","Split & Combine"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Splits the content of a selected column into several separate new columns. The data is always split at the same position(s) specified in the node&#39;s dialog. It appends a fixed number of columns to the input table, each carrying one part of the original column. The number of appended columns equals the number of specified split points plus one.\n <br />\n If the data in the selected column is shorter than the specified split point, the corresponding result column contains an empty string. Also missing values in the selected column will create empty strings in the result columns.</p>\n        ","shortDescription":"Splits cells in one column of the table at fixed positions into separate columns.","keywords":[],"deprecated":false,"streamable":true,"tags":["Manipulation","Column","Split & Combine","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6MzE3NUQxNDM4NzkzMTFFNUIyNjBENUZBOEI3RjgwMEUiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6MzE3NUQxNDI4NzkzMTFFNUIyNjBENUZBOEI3RjgwMEUiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDoxQzM1Rjk3RTE4MzUxMUU1ODEzQUUwRDBBNzRDODlBMiIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDoxQzM1Rjk3RjE4MzUxMUU1ODEzQUUwRDBBNzRDODlBMiIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PulUXWAAAACoSURBVHjanFNBDoMwDKsR79vgMXBm1+0xAz5o0m3Zgpa2lEiVqtoktlsQQmD4L+iG/MEAXCId0pd5eQ4RxNLd3SaNM/01VZceXedxkrVrvlPwAY8U1v6RV1BTrW6sR/FtZaqPm6wp2aAkOwckb8HLJvq3/JwCWjsanH4sGIsWhAxLtgojFs/PZMAzITIF1LwDeLfRVjRg9iG5I9/huZM1WJR+51JtAgwAwilImCoHl1AAAAAASUVORK5CYII=","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input","description":"DataTable with column to split."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Split Input","description":"DataTable with additional columns carrying the split input 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":"Split indices","description":"Enter the position(s) of the splits, separated by a comma. For example, the string &#34;ABCDEFG&#34; with the split points &#34;2,4&#34; creates three new columns carrying the results &#34;AB&#34;, &#34;CD&#34;, and &#34;EFG&#34;. The specified split points must be strictly increasing numbers larger than zero.","optional":false},{"name":"New column names","description":"Enter the name(s) for the appended columns separated by a comma. Names must be unique and not existing in the input table. Specify as many as you defined split points plus one. All newly created columns are of type String.","optional":false},{"name":"Column to split","description":"Select the column whose content should be split. Only String columns can be selected.","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":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.15347721822541965},{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.05995203836930456},{"id":"*eOn8ibZnxIkY7XhT","factoryName":"org.knime.base.node.preproc.stringmanipulation.StringManipulationNodeFactory","probability":0.05515587529976019},{"id":"*20rIDLuYXD4U8cnN","factoryName":"org.knime.base.node.preproc.colconvert.stringtonumber.StringToNumberNodeFactory","probability":0.050359712230215826},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.047961630695443645},{"id":"*jd2U-FYTI8jCbQls","factoryName":"org.knime.base.node.preproc.filter.row.RowFilterNodeFactory","probability":0.04316546762589928},{"id":"*sLTXYsycpYMwt_yW","factoryName":"org.knime.time.node.convert.stringtodatetime.StringToDateTimeNodeFactory","probability":0.0407673860911271},{"id":"*m1bkjcKm-b81Pkl6","factoryName":"org.knime.base.node.preproc.cellsplitbypos.CellSplitterByPosNodeFactory","probability":0.03117505995203837},{"id":"*IPAOkJNeJy0B8rPZ","factoryName":"org.knime.base.node.preproc.cellsplit.CellSplitterNodeFactory","probability":0.03117505995203837},{"id":"*6k1xlCi486vumV3V","factoryName":"org.knime.base.node.preproc.columnresorter.ColumnResorterNodeFactory","probability":0.023980815347721823}]}