Advanced Delimited Importing Options

Click the Advanced button in the Import Delimited Text File dialog box to display the Advanced delimited import options dialog box.

Character marking the start of a string. Select this option to specify the delimiter used to mark the start of a text value.

Character marking the end of a string. Select this option to specify the delimiter used to mark the end of a text value.

These options enable you to import text values with embedded commas, spaces, etc. For example, if you set these options to use double (") or single (') quotation marks as text boundaries and the text to be imported contains field separator characters, then those characters will be interpreted as part of a single string (e.g., "John Jones, Ph.D." uses the comma both as part of the text and as a separator after it). In this case, when Statistica imports the data, the quotation marks will be recognized as boundaries around the text values, keeping the text values and the embedded separator character together (the quotation marks will not be included as part of the imported text values).

Case delimiter escape character. Enter in this field the character used to disable specific row delimiters. This is useful if you need to ignore a particular carriage return/line feed and instead join the two rows together as one.

Variable delimiter escape character. Enter in this field the character used to disable specific column delimiters. For example, let us say that your column delimiter is spaces and commas, but you need to import a particular text value such as "Gabrielle Elaine, consultant". In this field enter "\" and then in your text file change this string to "Gabrielle\ Elaine\,\ consultant". When you import the file, this value will be imported as "Gabrielle Elaine, consultant".

Open quote escape character. Enter in this field the character used to disable specific row character marking the start of a string.

Close quote escape character. Enter in this field the character used to disable specific row character marking the end of a string.

V7 Free Import. Click this button to display the ASCII Free Import Options dialog box.