{"title":"Line Reader","nodeType":"Source","id":"*s_Y_nKnj8aCNvqRp","factoryName":"org.knime.base.node.io.filehandling.linereader.LineReaderNodeFactory2","factoryId":"org.knime.base.node.io.filehandling.linereader.LineReaderNodeFactory2","path":["IO","Read"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Reads lines from a file or URL. Each line will be represented by a single string data cell in a single row. The row prefix and column header can be specified in the dialog.</p>\n            \n            <p><i>This node can access a variety of different</i> <a href=\"https://docs.knime.com/2021-06/analytics_platform_file_handling_guide/index.html#analytics-platform-file-systems\" rel=\"ugc nofollow noopener noreferrer\"> <i>file systems.</i> </a> <i>More information about file handling in KNIME can be found in the official</i> <a href=\"https://docs.knime.com/latest/analytics_platform_file_handling_guide/index.html\" rel=\"ugc nofollow noopener noreferrer\"> <i>File Handling Guide.</i> </a></p>\n            \n        \n        ","shortDescription":"Reads lines from a file or URL.","keywords":[],"deprecated":false,"streamable":true,"tags":["IO","Read","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3hpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6NjI2QUIwMTUyRTJGMTFFNTlDM0VDM0JERTMzRTU5NUYiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6NjI2QUIwMTQyRTJGMTFFNTlDM0VDM0JERTMzRTU5NUYiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDplZWQ3MGZlZi02N2E0LTQ2YzQtOTA2Zi03MmM4NmZjYjk2YzYiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6MGIzNmFjOTctNWViYS00MGU3LTkxODktYmJlOGQ3ZDBmMjRlIi8+IDwvcmRmOkRlc2NyaXB0aW9uPiA8L3JkZjpSREY+IDwveDp4bXBtZXRhPiA8P3hwYWNrZXQgZW5kPSJyIj8+HyvuqgAAAFlJREFUeNrkk0kOACAIA6nx/1/GJRzUGMVUT/KAYUoKVFWYCUJOBOBVwMyWNyhkFuCO8OaIH0bIvRGzrr04NmjKpAUWV78wttS2d7wrN1jpYmMGxqDCkwADAI6HGjI7cIB7AAAAAElFTkSuQmCC","views":[],"inPorts":[],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Lines from the file(s)","description":"The lines as read from the file(s), each line represented by a single cell in a data row."}],"dynInPorts":[{"groupName":"File System Connection","groupDescription":"The file system connection.","types":[{"objectClass":"org.knime.filehandling.core.port.FileSystemPortObject","color":"178ba5","dataType":"File System"}]}],"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":"Type","description":"The selection mode.\n<ul><li><b>File</b> : Select a single file.</li><li><b>Files in folders</b> : Select a folder and apply filters to select files within it.</li></ul>","optional":false},{"name":"Source","description":"The path to the file or folder to select.","optional":false},{"name":"Include subfolders","description":"Whether to include subfolders when selecting multiple files within a folder.","optional":false},{"name":"Filter by file extension","description":"Enable filtering files by their extension (e.g. &#39;xlsx;xlsm&#39;).","optional":false},{"name":"File extensions","description":"Semicolon-separated list of file extensions to include (e.g. &#39;xlsx;xlsm;xls&#39;). Case-insensitive unless &#39;Case sensitive (extensions)&#39; is enabled.","optional":false},{"name":"Case sensitive (extensions)","description":"Treat the entered extensions as case sensitive when matching.","optional":false},{"name":"Filter by file name","description":"Enable filtering by file name pattern with wildcards or regular expression.","optional":false},{"name":"File name filter pattern","description":"Pattern for file name filtering. With type &#39;Wildcard&#39;, use &#39;*&#39; and &#39;?&#39;. With type &#39;Regex&#39;, enter a Java regular expression.","optional":false},{"name":"File name filter type","description":"Choose how to interpret the file name pattern: wildcard or regular expression.","optional":false},{"name":"Case sensitive (names)","description":"Make file name filtering case sensitive.","optional":false},{"name":"Include hidden files","description":"Include hidden files in the selection.","optional":false},{"name":"Include special files","description":"Include special file types (workflows etc).","optional":false},{"name":"Filter by folder name","description":"Enable filtering of folders by name pattern before descending into them.","optional":false},{"name":"Folder name pattern","description":"Pattern for folder name filtering. Use &#39;*&#39; and &#39;?&#39; with filter type &#39;Wildcard&#39;. With type &#39;Regex&#39;, enter a Java regular expression.","optional":false},{"name":"Folder name filter type","description":"Choose how to interpret the folder name pattern: wildcard or regular expression.","optional":false},{"name":"Case sensitive (folders)","description":"Make folder name filtering case sensitive.","optional":false},{"name":"Include hidden folders","description":"Descend into folders that are hidden (if they otherwise pass filters).","optional":false},{"name":"Follow symlinks","description":"Follow symbolic links while traversing folders (only relevant when selecting a folder).","optional":false},{"name":"File encoding","description":"Defines the character set used to read or write a file that contains characters in a different encoding. You can choose from a list of character encodings (UTF-8, UTF-16, etc.), or specify any other encoding supported by your Java Virtual Machine (VM). The default value uses the default encoding of the Java VM, which may depend on the locale or the Java property &#34;file.encoding&#34;.\n<ul><li><b>OS default</b> : Uses the default decoding set by the operating system.</li><li><b>ISO-8859-1</b> : ISO Latin Alphabet No. 1, a.k.a. ISO-LATIN-1.</li><li><b>US-ASCII</b> : Seven-bit ASCII, also referred to as US-ASCII.</li><li><b>UTF-8</b> : Eight-bit UCS Transformation Format.</li><li><b>UTF-16</b> : Sixteen-bit UCS Transformation Format, byte order identified by an optional byte-order mark in the file.</li><li><b>UTF-16BE</b> : Sixteen-bit UCS Transformation Format, big-endian byte order.</li><li><b>UTF-16LE</b> : Sixteen-bit UCS Transformation Format, little-endian byte order.</li><li><b>Other</b> : Enter a valid charset name supported by the Java Virtual Machine.</li></ul>","optional":false},{"name":"Custom encoding","description":"A custom character set used to read a CSV file.","optional":false},{"name":"Fail on differing specs","description":"If enabled and the specs of the files are different, the node will fail. This option is only relevant when reading multiple files in a folder.","optional":false},{"name":"Row header prefix","description":"Specifies the prefix of the row header. The default is &#34;Row&#34; and the resulting row headers are &#34;Row0&#34;, &#34;Row1&#34;, and so on.","optional":false},{"name":"Column header","description":"Select how the column header should be determined.\n<ul><li><b>Use first line as column header</b> : The name of the output column equals the first row of the read file.</li><li><b>Set column header</b> : The name of the output column can be set manually in the text field below. The default name is &#39;Column&#39;.</li></ul>","optional":false},{"name":"Column header name","description":"The name of the output column. The default is &#34;Column&#34;.","optional":false},{"name":"Empty line handling","description":"Select how empty lines should be handled.\n<ul><li><b>Replace with missing cells</b> : Empty lines will be replaced by a missing cell.</li><li><b>Replace with custom text</b> : Empty lines will be replaced by the text entered in the text field below.</li><li><b>Skip</b> : Empty lines will be skipped and are not added to the output.</li></ul>","optional":false},{"name":"Replacement text","description":"The text to use as replacement for empty lines.","optional":false},{"name":"Filter with regular expression","description":"Include in the output only lines matching the provided regular expression pattern. For example &#39;12.*&#39; will only match lines starting with 12 and have zero or more characters afterwards. The default value is &#39;.*&#39; which matches everything.","optional":false},{"name":"Append path column","description":"If enabled, the node will append a path column with the provided name to the output table. This column contains for each row which file it was read from. The node will fail if adding the column with the provided name causes a name collision with any of the columns in the read table.","optional":false},{"name":"Limit data rows","description":"If enabled, the number of rows which will be read and output by the node is limited to the specified value.","optional":false}]}],"links":[],"kudos":[{"accountId":"account:user:fd74d1b4-da47-4c58-86e7-4fdd8c45dce0","user":"lukass","date":"2021-11-12T09:51:03+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":[]}