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.

Option Description
Character marking the start of a string Specify the delimiter used to mark the start of a text value.
Character marking the end of a string Specify the delimiter used to mark the end of a text value.
Note: 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 are interpreted as part of a single string (for instance, "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 are recognized as boundaries around the text values, keeping the text values and the embedded separator character together (the quotation marks are not included as part of the imported text values).
Case delimiter escape character You can enter the character used to disable specific row delimiters. This is useful if you need to ignore a particular carriage return or line feed and instead join the two rows together as one.
Variable delimiter escape character You can enter 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 is imported as "Gabrielle Elaine, consultant".
Open quote escape character You can enter the character used to disable specific row character marking the start of a string.
Close quote escape character You can enter the character used to disable specific row character marking the end of a string.
V7 Free Import Displays the ASCII Free Import Options dialog box.