Configure the Text Tab

The properties in Text tab control the loading of text files. The default values on the text tab are dependent on the type of text data that is loaded (see Data Types).

Activity Steps

  1. Select the Data Loader Component from the Project Tree.
  2. Select the Data Loader tab at the bottom of the Main Canvas.
  3. Select the Text tab in the Property Panel.
  4. Configure the following options as required.
    • Delimited – Files that are delimited by a comma or other delimiter.
    • Fixed Width – Files that contain data with fixed width columns.
    • Load/Reload Data
    • Refresh Mapping – Update the column definitions in the Column Definition Table. Do this after changing one or more properties in the Data Loader Window.
    • Field Header Format – Select how column headers are formatted from NoHeader, FieldNames and FieldCount.
    • Field Header Line Num – The line number from which column headers start.
    • Text qualifier – Character used to define individual strings, where delimiters are used mid-string. For example, " could be used to define a string where commas have been used in the string and should not be interpreted as a delimiter. That is, "10,13" would be interpreted as a single string.
    • Ignore lines starting with
    • Delimited field group – Only available when Delimited is selected.
      • Delimiter – Character that marks the boundary between values. Select from Tab, Semicolon, Comma, Space and Other.
      • Other – Only available if Delimiter is set to Other.
      • Treat consecutive delimiters as one – Consecutive delimiter characters are interpreted as being part of the same delimiter. Can be used for space delimited or fixed format files where you often have at least one space separating columns.
    • Fixed width field group – Only available when Fixed width is selected.
      • Left aligned – All values and headers are left aligned. Leaving this option unchecked aligns all values and headers to the right.
      • Width – Apply the same fixed width for all the columns in the column definition table. the File Viewer to assess where the split should be.
      • Split column at – Split a data column at the entered offset. Useful where there are two consecutive column names without a space separator.
      • Combine columns – Combine two or more data columns by first selecting two or more consecutive data columns in the Column Definition Table.
      • Show column offsets – Display the Offsets column in the column definition table. View the results of column offsets in the File Viewer.
    • Show field group
      • First Values – Display the First Value column in the column definition table.
      • File viewer – Display the File Viewer on the main canvas. Used to view the data in the loaded file and determine appropriate data column offsets.
      • lines – Number of lines displayed in the File Viewer.