Information générale
Catégorie:
Codage, syntaxe et commandes
APPEND FROM FILE.TXT DELIMITED WITH CHARACTER ";"
>I have a semi-colon seperated text file that looks like the following:
>
>1;3AUP3MJDFSS12KPC00L80GGSK4;29UP3MJDFSS12KPC00L80GGSKLJXFWVF
>2;3AUP3MJDFSS12KPC00L80GGSK4;;MICHEL;JARNO;;29 RUE DE
>3;3AUP3MJDFSS12KPC00L80GGSK4;SAWDIATOU;SALL;;23 RUE DUGUAY
>4;3AUP3MJDFSS12KPC00L80GGSK4;Visa;11111111;12/99
>5;3AUP3MJDFSS12KPC00L80GGSK4;1950/00;2;22
>6;3AUP3MJDFSS12KPC00L80GGSK4;48.5;44.00;4.50;;False;;;US;
>7;IO
>
>I need to use the append from command to get it into my table. I can't get the syntax right for this. I have tried:
>append from [name of text file] type delimted with blank delimited with character ;
>and it does not work. I can't find any combination of the above that does work. Supposedly this is doable. Any help out there?
>
>Jill
Précédent
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