|
<< Click to Display Table of Contents >> Navigation: Reference Manual > Windows and dialog boxes > Raw CSV file treatment > Raw CSV file treatment |
From the Raw CSV file view window use [File] [Worksheet select] or [File] [Treatment and separator select].
This is used to switch the view to another worksheet, if the workbook contains more than one worksheet.
You need to use this if the CSV file does not contain the column headers in the first row of the file or the data does not start in row 2.
This is used to:
•Request that "short" lines are combined together if there are stray line endings in the middle of rows of data
•Select the row number that contains the headings (entry names)
•Select the row number where the data starts
•Select the separator used to delimit columns in the CSV file, the delimiter will normally be a comma or a tab character. Some countries may use other characters to delimit the columns