Odkaz jsme Vám odeslali na email.

Nepodařilo se nám odeslat odkaz na váš email. Zkontrolujte, prosím, Váš email.

Online nápověda

GEO5

Stromeček
Nastavení
Produkt:
Program:
Jazyk:

(3) Parameters for Input File Splitting into Columns

The program analyzes the input file and fills this part with the parameters obtained.

If the text file with delimiters is being imported, the following parameters are specified:

Text file with delimiters

  • the first and the last row to be loaded is determined, if any row contains a header and possibly the first and the last row of the header
  • determine the column separators by checking the switches of each type, or check "Other" and add another separator into the input line
  • "Treat consecutive delimiters as one" switch determines how the program will handle immediately following delimiters (even various types of delimiter)
  • text qualifiers specify whether the text columns are marked left and right with a character
  • comment qualifier specifies the character from which the contents of the file is ignored to the end of the row

The "Analyse delimiters" button reanalyses the parameters after changing the row range.

If the text file with fixed width is being imported, column count and width of each column is specified.

Text file with fixed width

  • the first and the last row to be loaded is determined, if any row contains a header and possibly the first and the last row of the header
  • the "Add" button inserts a column at the end of the list, the "Remove" button removes the last column
  • in the "Columns in the file" table the width of each column is specified

The "Analyse columns" button reanalyses the parameters after changing the row range.

If the spreadsheet file is being imported, only the first and the last row to be loaded is determined if a row contains a header and possibly the first and the last row of the header

Spreadsheet file

In all cases it is possible to check the result in the part (4) Input file split into columns. If everything is OK, go further by clicking "Next".