The following steps take place when a field uses an
ENCLOSED BY clause without also using a
TERMINATED BY clause.
Any whitespace at the beginning of the field is skipped.
The first non-whitespace character found must be the start of a string that matches the first
ENCLOSED BY delimiter. If it is not, then the row is rejected.
If the first
ENCLOSED BY delimiter is found, then the search for the second
ENCLOSED BY delimiter begins.
If two of the second
ENCLOSED BY delimiters are found adjacent to each other, then they are interpreted as a single occurrence of the delimiter and included as part of the data for the field. The search then continues for another instance of the second
ENCLOSED BY delimiter.
If the end of the record is found before the second
ENCLOSED BY delimiter is found, then the row is rejected.