Getting VB to sort numbers?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



I wonder if someone could point me in the right direction here. I
maybe just searching using the wrong terminology, but don't seem to
find anything that fits the bill.

"Number parsing in VB"
"Text parsing in VB"
etc...

Here is an example of the sort of thing I want to do:

Before:-
<snip>
################################################################################
# SYNOPS from 03002, Baltasound (United Kingdom) | 60-45N | 000-51W |
15 m
################################################################################
200909130850 AAXX 13094 03002 46382 /3507 10117 20098 30299 40318
52013 90850
333 81/08 87/12=
200909130750 AAXX 13084 03002 46380 /3208 10107 20098 30295 40313
51012 90750
333 81/08 83/11 87/14=
200909130650 AAXX 13074 03002 46470 /3408 10111 20093 30292 40310
53012 90650
333 81/11 87/17=
200909130550 AAXX 13064 03002 16475 /3309 10109 20091 30287 40305
53010 60002 90550
333 20103 3/009 70000 88/15=

################################################################################
# SYNOPS from 03005, Lerwick (United Kingdom) | 60-08N | 001-11W | 82
m
################################################################################
200909130850 AAXX 13094 03005 42484 83506 10115 20073 30218 40319
52011 888// 90850
333 55300 20334 82814 88618=
200909130750 AAXX 13084 03005 42482 73605 10110 20083 30215 40316
53013 878// 90750
333 55300 20207 83815 87620=
200909130650 AAXX 13074 03005 42481 83405 10106 20085 30210 40312
52012 885// 90650
333 55300 20104 88617=
200909130550 AAXX 13064 03005 11472 80108 10101 20087 30207 40308
53012 69902 72162 885//
90550 333 20101 31010 55045 55300 20007 70006
88615=

Note: The date/time is derived from the AAXX 13094 etc = 13th Sept
(The year is known to be 2009 based on the download). I need to
extract the remainder of the number into one file for each time (Note
I have just shown 2 two locations on a 4 hour time span, in reality
there are thousands of locations all of which have hourly data)

After:-
<snip>
and the output to be a number of text files that look like this :
1. 2009091306.txt
03002 16475 /3309 10109 20091 30287 40305 53010 60002 90550 333 20103
3/009 70000 88/15=
03005 11472 80108 10101 20087 30207 40308 53012 69902 72162 885//
90550 333 20101 31010 55045 55300 20007 70006 88615=

2. 2009091307.txt
03002 46470 /3408 10111 20093 30292 40310 53012 90650 333 81/11 87/17=
03005 42481 83405 10106 20085 30210 40312 52012 885// 90650 333 55300
20104 88617=

3. 2009091308.txt
03002 46380 /3208 10107 20098 30295 40313 51012 90750 333 81/08 83/11
87/14=
03005 42482 73605 10110 20083 30215 40316 53013 878// 90750 333 55300
20207 83815 87620=

4. 2009091309.txt
03002 46382 /3507 10117 20098 30299 40318 52013 90850 333 81/08 87/12=
03005 42484 83506 10115 20073 30218 40319 52011 888// 90850 333 55300
20334 82814 88618=

I'm not expecting someone to come up with all the coding, just hoping
I could be pointed towards a good tutorial that deals with this sort
of thing, or even a book.

I hope the question isn't to confusing.

Thanks

Keith (Southend)

ps: I am struggling to learn VB2008 Express atm, it's very much alien
to me, but am sure if somethings as small as it maybe I can do I can
build on it. The problem I'm finding is I have no examples to 'play'
with.
.



Relevant Pages

  • Re: Market Share, Tablets, and the Future of Computing
    ... This sort of augmented reality is not really all that far away. ... own window and letting the user sort it out. ... How do you propose to make use of such different sized screens without ...
    (comp.sys.mac.advocacy)
  • Re: George H.W. Bush will help President Hillary
    ... were attacked by Russia, to toss out an extreme example, would Britain ... opinion swings to the other. ... we're not in any sort of declining position. ...
    (soc.retirement)
  • Re: George H.W. Bush will help President Hillary
    ... were attacked by Russia, to toss out an extreme example, would Britain ... opinion swings to the other. ... This thread started with the defense of the notion that there are some sort ...
    (soc.retirement)
  • Re: An epidemic of cannabis use?
    ... What on *EARTH* gives you the idea that you're in any sort of position ... It's just my opinion. ... bit arrogant sometimes, but then again, I am king of the universe. ...
    (uk.people.support.depression)
  • Re: Awww, how cute
    ... I get the same sort of reactions from people ... I think if we'd had all this internet malarky when I was at school, ...
    (uk.people.support.depression)