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 check box 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 check box 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 check box 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 check box to create a new column that stores the name or URL of the source file.
    Store blank cells as nulls Select this check box to store blank cells as nulls.

    This check box is selected by default.

    Store blank rows Select this check box to store blank rows.

    This check box is selected by default.

  3. Click Next. Preview the source file information.
  4. Optional: On the "Get data from" page, select a way to upload another source file.
    See Uploading Data for more details.
  5. Click Done adding.

What to do next

Mapping Data