tFileInputDelimited Standard properties
These properties are used to configure tFileInputDelimited running in the Standard
Job framework.
The Standard
tFileInputDelimited component belongs to the File family.
The component in this framework is available in all Talend
products.
Basic settings
Property type |
Either Built-In or Repository. |
 |
Built-In: No property data stored centrally. |
 |
Repository: Select the repository file where the |
File Name/Stream |
File name: Name and path
Stream: The data flow to This variable could be already pre-defined in In order to avoid the inconvenience of hand Related topic to the available variables: see Warning: Use absolute path (instead of relative path) for
this field to avoid possible errors. |
Row separator |
The separator used to identify the end of a row. |
Field separator |
Enter character, string or regular expression to separate fields for the transferred |
CSV options |
Select this check box to specify the following CSV parameters:
It is recommended to use standard escape character, that is "". |
Header |
Enter the number of rows to be skipped in the beginning of file. Note that when dynamic schema is used, the first row of the input |
Footer |
Number of rows to be skipped at the end of the |
Limit |
Maximum number of rows to be processed. If |
Schema and Edit Schema |
A schema is a row description. It defines the number of fields Click Edit
Note that if the input value of any This This When using the dynamic schema feature, the dynamic |
 |
Built-In: You create and store the schema locally for this component |
 |
Repository: You have already created the schema and stored it in the |
Skip empty rows |
Select this check box to skip the empty rows. |
Uncompress as zip file |
Select this check box to uncompress the input |
Die on error |
Select the check box to stop the execution of the Job when an error Clear the check box to skip any rows on error and complete the process for To catch the |
Advanced settings
Advanced separator (for |
Select this check box to change the separator used for numbers. By default, the thousands separator is a comma (,) and the decimal separator is a period (.). |
Extract lines at random |
Select this check box to set the number of |
Encoding |
Select the encoding from the list or select Custom |
Trim all column |
Select this check box to remove the leading and trailing whitespaces from all |
Check each row structure against |
Select this check box to check whether the total number of columns |
Check date |
Select this check box to check the date format strictly against the input schema. |
Check columns to trim |
This table is filled automatically with the schema being used. Select the check |
Split row before field |
Select this check box to split rows before |
Permit hexadecimal (0xNNN) or octal |
Select this check box if any of your numeric types (long, integer, short, or byte type), will In the table that appears, select the check Select the Permit hexadecimal or octal check box to select This table appears only when the Permit hexadecimal |
tStatCatcher Statistics |
Select this check box to gather the processing |
Global Variables
Global Variables |
NB_LINE: the number of rows processed. This is an After
ERROR_MESSAGE: the error message generated by the A Flow variable functions during the execution of a component while an After variable To fill up a field or expression with a variable, press Ctrl + For further information about variables, see |
Usage
Usage rule |
Use this component to read a file and separate |
Limitation |
Due to license incompatibility, one or more JARs required to use |