Text Data - Drillhole Import Wizard - Step 2 of 3 (Delimited)

Summary

Use this wizard dialog to specify how the delimited data is formatted in the import data file.

 

Parameter Explanation Data Type
Column Delimiters

Microsoft Excel CSV

Select the Microsoft Excel CSV option if the import data is in CSV format.

 

Comma Delimited

Select the Comma Delimited option if the import data columns are separated by a comma.

 

White Space Delimited

Select the White Space Delimited option if the import data columns are separated by white space.

 

Tab Delimited

Select the Tab Delimited option if the import data columns are separated by a tab.

 

Other

Select the Other option if the import data columns are separated by another method.

Soft Hard

Select Soft if you want the delimiter to be flexible on recognizing spaces, commas, tabs, etc. For example, if you select Soft and a space is encountered in the column it will be ignored. If however, you select Hard and the same space was encountered, the column will be split into two.

 

String Handling

Quote character

Specify the "character" to be used for quotes. The default is ' " '.

 

Escapes?

Select Escapes? if there are escape sequences in your data.

Special characters in a string can be defined using escape sequences. An escape sequence consists of a backslash character (\) followed by one or more characters.

 

Preview window

Column Locations

The column locations, as have been determined by the parameters above, will be displayed in this window.

 

Next>

Click the Next> button to continue the import process.

 

Related Topics

Access MyGeosoft Support >> for online support and learning resources: Knowledge Base Articles, Guided Learning Path Lessons, Instructional Videos, Technical and Technology Papers, and Best Practices.