Parsing Line-Based Text Files

Data in a line-based text file is stored in a linear form. TIBCO Clarity can parse the source data from a line-based text file according to the configured parsing rules.

Procedure

  1. Click Character encoding to specify the the encoding method applied to your source file. By default, UTF-8 is selected.
  2. Define which data is parsed and how it is parsed with the following options:
    Option Description
    Parse every lines into one row Specify the number of lines you want to parse into one row. The default value is 1.

    For example, if you enter 2, TIBCO Clarity will parse every 2 lines into one row.

    Ignore first line(s) at beginning of data Select this option and enter the number of lines to be ignored at the beginning of the file when parsing the source data.

    Use this operation to omit the column header.

    Discard first row(s) of data Select this option and enter the number of rows to be discarded.

    This operation does not discard the column header you have specified.

    Skip last rows from end of data Select this option and enter the number of rows to be omitted from the end of data.
    Store file source (file names, URLs) in each row Select this option to create a new column that stores the name or URL of the source file.
    Store blank cells as nulls Select this option to store blank cells as nulls.
    Store blank rows Select this option to store blank rows.
  3. Click Next. Preview the source file information and click Done adding to add the source file.
  4. Optional: On the "Get data from" page, select a way to upload another source file. See Uploading Data for more details.

What to do next

Mapping Data