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.