Text-based data can be copied to the clipboard from a text-based file (for example, from Microsoft Excel) or from a web page.
|
Option |
Description |
|---|---|
|
Dataset Name |
The name of the dataset |
|
Separator |
Choose whether data on the clipboard is separated by delimiters or is entered in fixed-width columns. Delimiters are symbols, such as commas, tabs, or spaces, that separate fields in the data source and that will specify columns in the dataset in the application. |
|
Set first row as column names |
Select this check box to use the first row of data as column names in the dataset. Clear this check box to use the default column names ("Column1", "Column2", and so on). |
|
|
The format for numeric columns in the dataset |
|
|
The format for date columns in the dataset |
|
|
When acquiring data stored as fixed-width columns, analyze the data file and suggest column widths (in characters) for separating data into columns in the dataset. If the suggested widths aren’t suitable, you can change the widths by entering values separated by commas. For example, if your data is in three columns and the column widths are five, 10, and 15 characters, you would enter 5,10,15 in the Break Column box, and select Apply to see a preview of the resulting dataset. |
|
|
Select this check box to remove leading and trailing values from numbers and text in the dataset so that column headers do not appear as empty fields. For example, if a "Product" entry has a leading space (" Product"), the space is removed and "Product" appears as the column header. |