Information générale
Catégorie:
Codage, syntaxe et commandes
>I am having a problem importing or appending a fixed width text file into a table. The data I want to put into fields is not delimited but is separated by various numbers of spaces. The Import Wizard does what I want but I am trying to achieve the same in a stand-alone application. I have tried putting the text file into a temporary table and using substr() to parse the fields into another table but it takes quite a bit of time. Any help would be appreciated.
>
>example:
>Text file: 123456789 12345 123456
>
>Table: Field1 Field2 Field3 Field4 Field5 Field6
> 123456789 12345 123456
Create a .DBF that has the fileds in the same order and size as the text file... This file is called SDF (Standard Data Format)... once you have the table, make it the current work area and the command would be...
append from textfile.txt type sdf
I believe that will work.
BOb
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