Hey.
I've been asked to create a string slicing programme that will take data from a spreadsheet and output it to a delimited ASCII file. The data in the text file follows the structure as shown below:
<time:00:00:00:date:01/10/00:lat:52.34:long:28.30:wind:20:temp:-12recipitation:0.03:visibility:50>
The text file has about 7-8 rows off data following the same structure but with a few changes. So I want to remove the semi-colons from each row of data and format the text file so it has the correct columns on the first row and then the data below but with the long, lat removed etc. However I can't just remove all the semi colons as time uses them.
Time Date Lat Long Wind
Like that type of structure. I haven't got a clue how to start. I've read that I could read the text file into an array and then go from there.
Any help or pointers would be appreciated.
Cheers.
I've been asked to create a string slicing programme that will take data from a spreadsheet and output it to a delimited ASCII file. The data in the text file follows the structure as shown below:
<time:00:00:00:date:01/10/00:lat:52.34:long:28.30:wind:20:temp:-12recipitation:0.03:visibility:50>
The text file has about 7-8 rows off data following the same structure but with a few changes. So I want to remove the semi-colons from each row of data and format the text file so it has the correct columns on the first row and then the data below but with the long, lat removed etc. However I can't just remove all the semi colons as time uses them.
Time Date Lat Long Wind
Like that type of structure. I haven't got a clue how to start. I've read that I could read the text file into an array and then go from there.
Any help or pointers would be appreciated.
Cheers.
Last edited: