I am trying to append data from a tab delimited file where some of the fields are empty and there happens to be some commas in a few of the fields. I can use the import wizard and it works fine. It appears that the append function is having a problem with consecutive tabs follows by a string in double quotes that has a comma in the string. The result is the field is moved to the left one field and everything of off after that. I have included a sample line of data with the problem. I am appending into a nine field table with all character fields. I have also included the line of code that I am using and an small display of what should happen and what is happening.

SS Lori N "12 13th Pl, #236" Redmond WA 98052 SoSi


APPEND FROM (textFileName) TYPE DELIMITED WITH " WITH CHARACTER TAB

field should actual
1 SS SS
2
3 Lori N Lori N
4 12 13th Pl, #236
5 12 13th Pl, #236 Redmond
6 Redmond WA
7 WA 98052
8 98052 SoSi
9 SoSi

Please and thank you,

Scott Sherman