Decode vertical text file to horizontal text file

[wooli]

Hi Jonh,

Thanks for your reply,

Your suggested programming is not what I want.



Additional information.


I'm a land surveyor and use 3rd party software for reductions.


I've never been happy with this software's options for data manipulation and reports and would like to develop my own workaround using excel/vba.


All I want is advice on the overall structure for a VBA/Excel program to extract and manipulate the data as a report and/or for further processing by other software.


After doing a field survey, the output is a vertical file in the following format:


50=190615
0=P20
0=P20
0=P20.1
23=1112
2=20
37=381.708
38=461.458
39=1.267
62=3
37=426.659
38=433.330


The number to the left of the '=' sign is a label and the number/text to the right is the data value.


When doing a survey, each station or reading may consist of 5 to 15 of the above codes for that particular group.


The start of each group is usually delineated by the labels 0, 5 or 61 (and sometimes others).


I've attached a file showing all the codes. (I only use about 30 of these codes)



So in the above extract I want to extract data and produce a file as follows:


20,461.458,381.708,1.267


From a program structure point of view, am I better off inputting all the codes to an Excel file and using vlookup (or similar) for program control, or should I just include all the codes in the program and use a CASE statement to control looping?

(For some reason, I couldn't attach a TXT or PDF file but it worked when I combined them in a ZIP file)

Thanks

Michael