General information
Category:
Coding, syntax & commands
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only