Defining the file path, format, and marker positions - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-29

Procedure

  1. Specify the full path of the source file in the File field, or click the Browse... button to search for the file.
    Note: The Universal Naming Convention (UNC) path notation is not supported. If your source file is on a LAN host, you can first map the network folder into a local drive.
  2. Select the Encoding type and the OS Format the file was created in. This information is used to prefill subsequent step fields. If the list doesn't include the appropriate format, ignore the OS format.
    File - Step 2 of 4 dialog box.
    The file is loaded and the File Viewer area shows a file preview and allows you to place your position markers.
  3. Click the file preview and set the markers against the ruler to define the file column properties. The orange arrow helps you refine the position.
    File Viewer dialog box.
    The Field Separator and Marker Position fields are automatically filled with a series of figures separated by commas.
    The figures in the Field Separator are the number of characters between the separators, which represent the lengths of the columns of the loaded file. The asterisk symbol means all remaining characters on the row, starting from the preceding marker position. You can change the figures to specify the column lengths precisely.
    The Marker Position field shows the exact position of each marker on the ruler, in units of characters. You can change the figures to specify the positions precisely.
    To move a marker, press its arrow and drag it to the new position. To remove a marker, press its arrow and drag it towards the ruler until a remove icon appears.
  4. Click Next to continue.