{"title":"Fixed Width File Reader","nodeType":"Source","id":"*A0XkYudtYHPfC_2T","factoryName":"org.knime.base.node.io.fixedwidthfr.FixedWidthFRNodeFactory","factoryId":"org.knime.base.node.io.fixedwidthfr.FixedWidthFRNodeFactory","path":["IO","Read"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node can be used to read data from an ASCII file or URL location. It reads files where a column is defined by the number of characters and not by a column delimiter.\n <br />\n When you open the node&#39;s configuration dialog and provide a filename, the reader creates one column. This column shows only the remaining characters in the preview table and won&#39;t be appended to the output table.\n <br /></p><p>The preview shows only the first couple of lines. It could happen then, that the preview appears looking fine, but the execution of the Fixed Width File Reader fails.\n <br /></p>\n        ","shortDescription":"Fixed column width reader for ASCII files.","keywords":[],"deprecated":false,"streamable":false,"tags":["IO","Read"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6NTBEMDY1NUI3RjI5MTFFNUE3NjBCMzY2NkE3NjU5N0EiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6NTBEMDY1NUE3RjI5MTFFNUE3NjBCMzY2NkE3NjU5N0EiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDo3NDgxNzYxQTJFMkYxMUU1OUMzRUMzQkRFMzNFNTk1RiIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDo3NDgxNzYxQjJFMkYxMUU1OUMzRUMzQkRFMzNFNTk1RiIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PsM6qsoAAACWSURBVHjaYuyeuuo/A2HAWJIVilWCBUSkJPljlZwzbyOM+b9n2mqshjAxEA9AhlBkAG4v4ALIXkPyDnVdQJYBjIyM/4GYYheADcEbBoKc7BiaSrNR+bSNhffff6LHAmNpdhjYZlhwMOFxLl5xkGYMF+BRjPD0//+gWGDE6gVkJxNjKMgwFnyacYmDNKK4AFcyJQYABBgAB14xCJ1RPrgAAAAASUVORK5CYII=","views":[],"inPorts":[],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"File Table","description":"Datatable just read from the file"}],"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":[{"fields":[{"name":"ASCII file location","description":"Enter a valid file name or URL. When you press ENTER, a preview of the file is shown. You can also choose a previously read file from the drop-down list, or select a file from the &#34;Browse...&#34; dialog.","optional":false},{"name":"Preserve user settings","description":"If checked, the checkmarks and column names/types you entered are preserved even if you select a new file. By default, the dialog starts with fresh default settings for each new file location.","optional":false},{"name":"Click on add","description":"A new dialog opens where column properties can be set:\n<ul><li>Number of columns to add: Specify a number of columns you would like to add.</li><li>Name/Prefix: Set a unique column name or prefix if more than one column should be added.</li><li>Width: The width of the column in number of characters.</li><li>Type: Choose a type.</li><li>Missing Value Pattern: Pattern for which a &#34;missing cell&#34; will be created.</li><li>DON&#39;T include: The Fixed Width File reader skips this column.</li></ul>","optional":false},{"name":"Click on edit","description":"A new dialog opens with the column settings set. Each entry can be changed and the current column will be replaced.","optional":false},{"name":"Click on remove","description":"The selected columns will be removed.\n<br />\nNote: You can&#39;t remove the first column if &#34;Read RowIDs&#34; is selected.","optional":false},{"name":"Read RowIDs","description":"If checked, the first column in the file is used as RowIDs. If not checked, a default row headers are created.","optional":false},{"name":"Read column headers","description":"If checked, the items in the first line of the file are used as column names. Otherwise default column names are created.","optional":false},{"name":"Click on the table header","description":"If the column header in the preview table is clicked the edit dialog will open.","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":"*jd2U-FYTI8jCbQls","factoryName":"org.knime.base.node.preproc.filter.row.RowFilterNodeFactory","probability":0.1},{"id":"*Oy714gpoifm4PiOZ","factoryName":"org.knime.base.node.io.csvwriter.CSVWriterNodeFactory","probability":0.05714285714285714},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.05714285714285714},{"id":"*AApA5VHd41CVDe7u","factoryName":"org.knime.base.node.meta.looper.LoopEndNodeFactory","probability":0.05714285714285714},{"id":"*eOn8ibZnxIkY7XhT","factoryName":"org.knime.base.node.preproc.stringmanipulation.StringManipulationNodeFactory","probability":0.05714285714285714},{"id":"*XczpdBQ71RiIT9IL","factoryName":"org.knime.knip.base.nodes.filter.VarianceFilterNodeFactory","probability":0.04285714285714286},{"id":"*QNB4FsAPnEAgOMVh","factoryName":"org.knime.base.node.jsnippet.JavaSnippetNodeFactory","probability":0.02857142857142857},{"id":"*uVmaGQkzUOFCTqUe","factoryName":"org.knime.base.node.preproc.pmml.missingval.compute.MissingValueHandlerNodeFactory","probability":0.02857142857142857},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.02857142857142857},{"id":"*IPAOkJNeJy0B8rPZ","factoryName":"org.knime.base.node.preproc.cellsplit.CellSplitterNodeFactory","probability":0.02857142857142857}]}