Bonjours à tous
Voila mon soucie:
Mon travail actuellement est de réaliser un routine qui puisse aller récupérer des infos dans un fichier au format *.txt (généré par un autre logiciel) sans charger le fichier dans execl (fichier trop gros).
j'aimerai donc que l'on me donne (si possible) les fonction permettant de charger dans un variable les éléments désirer depuis un fichier txt.
le fichier txt est de la forme suivante
D'avance Merci de vos réponses
Code : Sélectionner tout - Visualiser dans une fenêtre à part
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
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145 $TITLE = NX NASTRAN STATIC ANALYSIS SET 1 $SUBTITLE= 5,4G UWD 2 $LABEL = 3 $SPCF 4 $REAL OUTPUT 5 $SUBCASE ID = 1 6 1 G -9.139905E+00 6.904522E+01 -2.093224E+03 7 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 8 2 G -2.711373E+02 1.931295E+02 -2.885030E+03 9 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 10 3 G -3.527461E+02 1.784156E+01 -5.623540E+02 11 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 12 4 G -2.358710E+02 -2.369611E+02 -1.347328E+03 13 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 14 5 G 5.315911E+02 0.000000E+00 0.000000E+00 15 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 16 6 G 3.373032E+02 -4.305523E+01 -1.983654E+01 17 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 18 21 G 3.782254E+02 -5.498864E+02 -4.154161E+03 19 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 20 22 G -3.329382E+02 -2.799396E+02 0.000000E+00 21 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 22 23 G 1.136550E+02 1.171806E+02 0.000000E+00 23 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 24 24 G -7.260596E+01 2.912323E+02 0.000000E+00 25 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 26 25 G 1.080118E+02 4.279382E+02 -2.782424E+03 27 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 28 26 G -7.506267E+00 -7.165909E-01 1.740864E+00 29 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 30 27 G 2.193777E+01 0.000000E+00 0.000000E+00 31 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 32 28 G -1.444761E+02 -8.906825E+00 4.104642E+00 33 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 34 29 G -6.430341E+01 3.098239E+00 1.427441E+00 35 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 36 41 G -2.261933E+02 3.534955E+02 -1.406467E+03 37 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 38 42 G -1.552025E+03 -2.751145E+02 -7.182606E+03 39 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 40 43 G 1.291296E+02 2.628525E+02 -1.250523E+03 41 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 42 44 G 8.351477E+02 -3.473876E+02 -8.989839E+03 43 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 44 45 G 5.793293E+02 2.313825E-01 -1.309712E-01 45 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 46 46 G 2.346118E+02 5.922696E+00 -2.684050E+01 47 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 48 $TITLE = NX NASTRAN STATIC ANALYSIS SET 49 $SUBTITLE= 9G FWD 50 $LABEL = 51 $SPCF 52 $REAL OUTPUT 53 $SUBCASE ID = 2 54 1 G -1.688538E+03 -7.905795E+02 1.901408E+03 55 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 56 2 G -2.239162E+03 9.181408E+02 -2.737919E+03 57 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 58 3 G -9.844182E+02 -3.236518E+02 1.107253E+03 59 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 60 4 G -1.335930E+03 1.118312E+01 -3.559328E+02 61 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 62 5 G -3.816306E+03 0.000000E+00 0.000000E+00 63 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 64 6 G -1.448601E+03 1.849073E+02 8.519111E+01 65 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 66 21 G -8.812055E+02 -6.950667E+02 -2.740090E+02 67 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 68 22 G -1.614686E+03 -5.949654E+02 0.000000E+00 69 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 70 23 G -1.707277E+03 1.437971E+03 0.000000E+00 71 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 72 24 G -8.613350E+02 1.148337E+03 0.000000E+00 73 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 74 25 G -7.138115E+02 -9.561930E+02 -4.840894E+02 75 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 76 26 G -3.116336E+03 -2.975032E+02 7.227451E+02 77 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 78 27 G -1.332370E+03 0.000000E+00 0.000000E+00 79 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 80 28 G -9.675672E+02 -5.964967E+01 2.748909E+01 81 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 82 29 G -3.542635E+02 1.706897E+01 7.864127E+00 83 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 84 41 G -6.039561E+03 -1.299364E+03 9.031304E+03 85 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 86 42 G -5.943315E+03 3.242488E+03 -5.024329E+03 87 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 88 43 G -1.799165E+03 -1.416272E+03 -8.671328E+03 89 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 90 44 G -6.743162E+03 -4.772184E+02 4.453806E+03 91 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 92 45 G -9.079697E+03 -3.626405E+00 2.052682E+00 93 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 94 46 G -1.822446E+03 -4.600703E+01 2.084949E+02 95 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 96 $TITLE = NX NASTRAN STATIC ANALYSIS SET 97 $SUBTITLE= -2.4G SWD 98 $LABEL = 99 $SPCF 100 $REAL OUTPUT 101 $SUBCASE ID = 3 102 1 G 5.750687E+01 6.806415E+02 1.888980E+03 103 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 104 2 G 4.581821E+02 4.903943E+02 9.129130E+03 105 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 106 3 G -3.110507E+02 7.453119E+02 -1.278569E+03 107 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 108 4 G -4.190768E+02 1.092575E+03 -9.767737E+03 109 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 110 5 G 6.938820E+02 0.000000E+00 0.000000E+00 111 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 112 6 G -4.794436E+02 6.119880E+01 2.819571E+01 113 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 114 21 G -1.568963E+02 6.626935E+02 1.069798E+03 115 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 116 22 G -1.678514E+01 8.166874E+02 0.000000E+00 117 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 118 23 G 1.612026E+02 7.986789E+02 0.000000E+00 119 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 120 24 G -5.711943E+01 3.420972E+02 0.000000E+00 121 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 122 25 G 6.963240E+01 4.555136E+02 -1.068383E+03 123 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 124 26 G 5.065799E+00 4.836100E-01 -1.174867E+00 125 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 126 27 G -6.715522E+00 0.000000E+00 0.000000E+00 127 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 128 28 G 3.294053E+01 2.030755E+00 -9.358578E-01 129 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 130 29 G -3.132489E+01 1.509282E+00 6.953663E-01 131 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 132 41 G 1.302132E+03 2.573365E+03 7.266988E+03 133 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 134 42 G -1.414418E+03 1.683370E+03 -7.328225E+03 135 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 136 43 G -6.190877E+02 1.934473E+03 6.703193E+03 137 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 138 44 G 7.676631E+02 2.187997E+03 -6.635374E+03 139 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 140 45 G -9.401708E+01 -3.755016E-02 2.125480E-02 141 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 142 46 G 5.772779E+01 1.457319E+00 -6.604282E+00 143 -CONT- 0.000000E+00 0.000000E+00 0.000000E+00 144
Partager