Specifying conversion options for CSV and TXT files in folder data sources

You use the Settings tab of the Import Parameters wizard to specify how QMF will convert the data of the CSV or TXT file into a table in the folder data source.

1. Click the Settings tab of the Import Parameters wizard.
2. Select the Skip rows starting with check box and specify a string in the text field to exclude certain rows from the result set.
3. Select what symbol is used to display decimal points in the file in the Decimal separator drop-down list.
4. Select the First row contains column names check box to specify that the first line of the file contains the names of columns to be created.
5. To specify that the columns will be created based on a fixed set of character lengths, click Fixed width and then specify the specific widths of the columns by entering the character lengths in the Specify columns width field.
   When each character length is reached in the text, the characters after that point are placed in a separate column, regardless of the content of the text.
6. To specify that the columns will be created automatically by breaking at certain symbols, click Separated by and then selecting the symbols check boxes below.
   When the result set is made, each time these symbols are encountered in the text, the characters after the symbol are placed in a separate column.
7. Select the Merge separators check box to consolidate columns that are created by multiple adjacent separators into one column.
   For example, if Comma and Space are selected and the text includes the string NAME, DEPT, three columns will be created. The first column contains NAME, and was created when the comma was encountered. The second column is empty, and was created when the space was encountered. The third column contains DEPT, and was created when the remaining text was encountered. By selecting the Merge separators check box, only one column is created when the comma and the space are encountered.
8. Select whether a single or double quotation marks are used to delineate text in the Text qualifier drop-down list. Text that is contained in the specified quotes is always displayed as is, whether it contains a separator symbol or not.
9. In the Preview pane, you can track how each selection changes the layout of the result set.