Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Append From difficulties
Versions des environnements
Network:
Windows 2000 Server
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement