Interlogix Topaz Reference Manual - Manual (Page 27)

23
Now separate the multiple data that is contained in some of the columns from the imported database.
In our sample, all Security Areas in the imported database are contained in the single column
AREANAME. While we were renaming the columns, we inserted a column for each additional piece
of data in that one column. Click on the gray bar above the cell that contains the data that needs to
be redistributed to the cells to the right. This highlights the entire column
.
Now click the Data menu and select Text to Columns... to display the following Wizard dialog box.
The text data in the field is separated (delimited) by a vertical line ( | ). Be certain that the radio dot is
in the Delimited option and click Next.
The next Wizard dialog box allows you to select the type of delimiter the text uses. In our sample, the
delimiter is a vertical line so the check mark is placed in the Other: option and a vertical line is typed
into the window beside the option. When the correct delimiter is selected, the Data preview window
displays the data in columns as shown below