Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
fixed column data
Can anyone help me with a program that reads a data file. The data file
reads the following information: $ELEMENT ID = 800000 IDENTIFIED BY TIME 8 0.000000E+00 -2.310368E-01 -4.983161E-01 3.032406E-02 9 -CONT- -3.499301E-01 6.825016E-01 -9.688503E-01 10 1.000000E-03 -1.482825E+01 3.571170E+00 5.367560E+01 11 .... .... 5.000000E-02 -2.275676E+00 4.481227E+00 2.024647E+01 109 -CONT- -2.396308E+02 -3.661783E+01 -4.990652E+01 110 ... (data repeats with element ID increasing) ... $ELEMENT ID = 800058 IDENTIFIED BY TIME 6388 0.000000E+00 1.008979E-01 -2.118058E-01 8.690994E-02 6389 -CONT- -8.416289E-01 -1.098713E-01 8.560615E-01 6390 1.000000E-03 8.365435E-01 -3.808490E+00 -2.597483E-01 6391 .... .... 5.000000E-02 -2.112889E+00 -1.135966E+01 3.044809E-01 6489 -CONT- 5.165210E+01 -9.663095E+00 -1.797665E+01 6490 ... ... $ELEMENT ID = 800059 IDENTIFIED BY TIME 6398 etc The output in Excel reads: ELEMENT ID = 800000 0.000000E+00 -2.310368E-01 -4.983161E-01 3.032406E-02 9 1.000000E-03 -1.482825E+01 3.571170E+00 5.367560E+01 11 ..etc 5.000000E-02 -2.275676E+00 4.481227E+00 2.024647E+01 109 (skip 2 rows once before the next ELEMENT ID = ??) ELEMENT ID = 800058 0.000000E+00 1.008979E-01 -2.118058E-01 8.690994E-02 6389 1.000000E-03 8.365435E-01 -3.808490E+00 -2.597483E-01 6391 ..etc 5.000000E-02 -2.112889E+00 -1.135966E+01 3.044809E-01 6489 (skip 2 rows once before the next ELEMENT ID = ??) ELEMENT ID = 800059 ..etc Thanks to everyone in advanced. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transpose Data with fixed first column | Excel Discussion (Misc queries) | |||
How do I format the A/ B Column to be fixed like numeric column | Excel Worksheet Functions | |||
How do I format the A/ B Column to be fixed like numeric column | Excel Worksheet Functions | |||
Offset from a variable column to a fixed column | Excel Programming | |||
Help: How do I create a column of fixed width data? | Excel Programming |