>I have a text file that i need to pull into a table.
>
>The table looks like this:
>": OUTSIDE DIA.:"
>"NOM (LSL, USL) = 1.1875 (1.1870, 1.1875)"
>"Subgroup" 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67
>"X" 1.1874 1.1873 1.1874 1.1872 1.1875 1.1875 1.1873 1.1873 1.1873 1.1872 1.1873 1.1873 1.1873 1.1872 1.1873 1.1874 1.1873 1.1873 1.1873 1.1873 1.1874 1.1873 1.1875 1.1873 1.1874 1.1874 1.1873 1.1874 1.1873 1.1874 1.1873 1.1872 1.1874 1.1873 1.1874 1.1873 1.1872 1.1872 1.1873 1.1873 1.1873 1.1873 1.1873 1.1873 1.1873 1.1873 1.1872 1.1873 1.1874 1.1873 1.1873 1.1873 1.1873 1.1874 1.1873 1.1873 1.1873 1.1873 1.1874 1.1873 1.1874 1.1874 1.1873 1.1873 1.1874 1.1872 1.1873
>
>EOF*****************
>
>When I try to use append from I get mixed results. Typically I only get the items that are conatined in quotes. The numeric values are not contained in quotes. They are separated by tabs.
>I have tried:
>"with blank" I get only the items in quotations
>"with tab" I get only the items in quotations
>with ' ' I get each entire line inside the field, this is the only way I have been able to get the numbers in, but the field lengths are too long, greater than 254.
>
>In the VFP help, it includes the following example:
>APPEND FROM mytxt.txt DELIMITED WITH _ ; WITH CHARACTER *
>
>However, when I try this example, I get an error, "command contains unrecognized phrase or key word? I am changing the charachter and delimiter of course.
>
>I am trying to acheive data organized as:
>subgroup Outside Dia
>1 1.1874
>2 1.1873
>3 1.1874
Steve,
File format is not suitable for "append from" command. You have to process it by yourself using alines, chrtran, strextract etc
Cetin