>>Peter,
>>
>>I doubt that you may get consistent result with inconsistent information here. The delimited format has limitations, and you ran in one of it when using delimiters that were already used as information piece.
>
>How do you mean, inconsistent information?

I mean, there are Special/Reserved characters that are used for special purposes, and here they are (quotation marks, ", ') used in particular for delimiting.
If the record contains those characters, then it is no common way to recognize some of them as information, others as delimiters.

>
>>You need to use the delimiter other than double or singles quotes here.
>
>Most notably the 1st statement is often advised here.
>
>>By the way, I did not have any problem with your fourth statement; and it was the only one that gave the consistent result.
>
>What a coincidence! For the sake of clear code I added a space behind the quote. Please redo the statement, but now without the additional space:
>

append from tabdeli.txt type delimited with '  with character TAB
>append from tabdeli.txt type delimited with ' with character TAB

Anyway it would be better to avoid using reserved characters/words for not their direct purposes. Otherwise you may get unexpected results.