ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Importing/Exporting Blocks of Data (https://www.excelbanter.com/excel-programming/333217-importing-exporting-blocks-data.html)

Lightning Brian

Importing/Exporting Blocks of Data
 
I've got a text file with blocks of data that consist of 20 rows, but each
row has a different amount of columns and a different amount of sizes for
each item in the row.

Here is an example.

74 71 65 72 72 75 73 58 66 63
63 71 71 71 76 42 10 0 1 4 1
1973 24 6 1250000 0 1991 4 17 98
0 0 0 0
0 0 0 0
179000 3000 908 0 0 0
0 0 0 0 0 0
0 14350231 0 17560676 0 0 14350289 0 14350163 0
0 0 0 0 0 12450853 0 14450301 0 0
0 0 0 0 14450297 16650373 96670803 0 14450571 0
0 0 0 0 4 190 8 3
0 0 0 0 0
-
Name
performance data
Other Text
050105085095080090060095100100085100100
1.18 (2.6.2002)
1.18 (2.6.2002)
0 0 98 65 70

I'm looking to find a starting point on importing this data into Excel
(which I can already do with a seperate program in a very round about way)
and then after manipulation exporting it back into this format.

I'm a little bit familiar with VB, I had to write some macros to automate
the process of getting the previous files exported out of the other program
into excel, as well as sending a listing of rows to seperate sheets based on
criteria.

Any help pointing me in the right direction would be much appreciated.


All times are GMT +1. The time now is 05:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com