Rockwell Automation 1492-PRINT110_PRINT220 ClearTools User Manual - Manual (Page 133)

User Manual Importing files

127
The examples are a two-column file in Excel, with the semicolon defined as the delimiter as
shown on the right. Because there is no data before the semicolon on row two, for example, the
first column is empty.
The file on the right was saved from within Excel in CSV format (fields separated by characters).

Click on Next to go to the next step.



The program suggests the characters to delimit the columns. If a different delimiter has been
used, you can select it by clicking the appropriate radio button.

If you click the other radio button, you can select another delimiter in the field next to this.

To use different delimiters on an additive basis, enter them in the Others field and enable
the "Keep 'Other' Delimiters" option.
This option is only available if the CSV filter was selected in step 2.

A new column starts at the points at which there is a delimiter.

Define the first and last import lines.
Source file with fixed column width

Select the option "Fixed width..." if the source file contains fixed-width columns, for example
column 1 = 10 characters, column 2 = 2 characters.