Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Append from text file help
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
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