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.

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.

Copyright © Cloud Software Group, Inc. All Rights Reserved.