Import a Delimited File
Top  Previous  Next

To import a delimited file you can use any of the methods you would ordinarily use to import a file to Zoot. During the import process, you'll be given the option to import the file as a delimited file, so watch for it. Zoot offers 3 kinds of delimited file import:

·Comma Separated Values (CSV)  
·Tab Separated Values (TSV)  
·User Specified Delimiter  


Comma/Tab Separated Values
Choose this option to import files that have been exported from another program using the standard Comma or Tab separated value format. Zoot imports the file and creates items and delimited fields accordingly.


User Specified Delimiter
This option lets you import a file using some other delimiter with which to extract items. In this case, Zoot displays a Delimited File Dialog so that you can specify a delimiter. A delimiter is any unique string of characters that marks the end of one item and the beginning of the next. In many cases you can specify a series of carriage returns (CRLF) as your delimiter. In other words, you can use "white space" as a delimiter.

When Zoot displays the Delimited File Dialog, follow these steps:

1. The Delimited File Dialog features two large edit boxes. The edit box on the top is where you enter the delimiter that marks the end of one item and beginning of the next. Zoot will use this delimiter to split the file into individual items.  
 
2. In the edit box on the bottom you can specify another delimiter that Zoot will use to locate an intelligent name for the items created during the import process. This delimiter is optional, but if you're importing a file full of e-mail messages, for instance, you might want to specify "Subject:" as a delimiter so that Zoot will pick up the subject line of each e-mail message.  
 
3. For each of the delimiters you can choose to have the delimiter itself omitted. This is useful if the delimiter you're using consists of "white space" or garbage characters.  

When you're finished specifying your delimiters, click the OK button and Zoot will execute the file import.