| //// |
| Licensed to the Apache Software Foundation (ASF) under one |
| or more contributor license agreements. See the NOTICE file |
| distributed with this work for additional information |
| regarding copyright ownership. The ASF licenses this file |
| to you under the Apache License, Version 2.0 (the |
| "License"); you may not use this file except in compliance |
| with the License. You may obtain a copy of the License at |
| http://www.apache.org/licenses/LICENSE-2.0 |
| Unless required by applicable law or agreed to in writing, |
| software distributed under the License is distributed on an |
| "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| KIND, either express or implied. See the License for the |
| specific language governing permissions and limitations |
| under the License. |
| //// |
| :documentationPath: /plugins/transforms/ |
| :language: en_US |
| :page-alternativeEditUrl: https://github.com/apache/incubator-hop/edit/master/plugins/transforms/loadfileinput/src/main/doc/loadfileinput.adoc |
| = Load file content in memory |
| |
| == Description |
| |
| Loads the file content in memory. |
| |
| == Options |
| |
| === File Tab |
| |
| [width="90%", options="header"] |
| |=== |
| |Option|Description |
| |Filename is defined in a field|Takes a filename from a field |
| |get filename from a field|A field containing the filename |
| |File or directory|The file or directory path to be added |
| |Add|Adds the file or directory to the selected files |
| |Browse|Uses the local file browser to select a path |
| |Regular Expression|Allows files to be included based on a regular expression |
| |Exclude Regular Expression|Allows files to be excluded based on a regular expression |
| |Selected files|The selected files to load into memory |
| |Show filename(s)|Previews the selected files |
| |=== |
| |
| === Content Tab |
| |
| [width="90%", options="header"] |
| |=== |
| |Option|Description |
| |Encoding|The file encoding (UTF, ISO, ...) |
| |Ignore empty file|Ignores empty files |
| |Ignore missing path|Ignores missing paths |
| |Limit|Limit the rows loaded from the file |
| |Include filename in output?|Allows the filename to be included in the output |
| |Filename fieldname|Field containing the filename |
| |Rownum in output?|Allows the row number to be included in the output |
| |Rownum filename|Field containing the row number |
| |Add files to result filesname|Add files to resulting files name |
| |=== |
| |
| === Fields Tab |
| |
| The fields to load from the file. |
| |
| [width="90%", options="header"] |
| |=== |
| |Option|Description |
| |Name|The name of the imported field. |
| |Element|File content or size |
| |Type|The data type for this field |
| |Format|The format mask |
| |Length|The field length |
| |Precision|The precision option depends on the field type, but only Number is supported; it returns the number of floating point digits |
| |Currency|Symbol used to represent currencies |
| |Decimal|A decimal point; this is either a dot or a comma |
| |Group|A method of separating units of thousands in numbers of four digits or larger. This is either a dot or a comma. |
| |Trim type|Type of trim: none, left, right, both |
| |Repeat|Enter ‘Y’ if you want to reuse the value from the last non-empty row when the corresponding value in this row is empty. Enter ‘N’ to leave the row empty. |
| |Get fields|Retrieve available fields based on the file contents |
| |=== |
| |
| === Additional output Tab |
| |
| [width="90%", options="header"] |
| |=== |
| |Option|Description |
| |Short filename field|The field name that contains the filename without path information but with an extension. |
| |Extension field|The field name that contains the extension of the filename. |
| |Path field|The field name that contains the path in operating system format. |
| |Is hidden field|The field name that contains if the file is hidden or not (boolean). |
| |Last modification field|The field name that contains the last modification. |
| |Uri field|The field name that contains the URI. |
| |Root uri field|The field name that contains only the root part of the URI. |
| |=== |
| |
| === Buttons |
| [width="90%", options="header"] |
| |=== |
| |Option|Description |
| |Preview rows|Preview the rows generated by this transform. |
| |=== |