General information
Category:
Coding, syntax & commands
>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
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