Hello all,
Another quick question,
The file that I have is rather large ie , stream = 30, message = 1200,
DATA = 800,000. as well the data records which are homed under the message
feild do not cycle the same ie data under Message 1 could have 672 records
data under message B could have 1200 records(see eg 1). As well their is no
consistancy as to how many messages you can have under a stream ie stream 1
could have 100 messages and stream 2 could have 320. The only thing that is
consistent is stream 1 is in the beginning row of the sequence message 2
is on the next row and the data is on consecutive rows until the sequence
has ended ie 1 to 672. after the data sequence has ended the next row could
either be a message or a stream depending on where in the cycle you are ie.
if stream 1 has 100 mesages the next feild that would show up after the
data sequence has finished would be another message until the 100 messages
has finished. After the data in 100th message was at its last record the
next record would be the stream. See eg 2 I need to have this 1column put
into 3 columns see eg 3 Could anyone help me with this being a beginner
programmer this has really stumped me.
your help is appreciated
note: -------- denotes number gap ie: numbers between 4 and 672
eg 1
stream 1
message 1
data 1
data 2
data 3
data 4
- - - - -
data 672
message 2
data 1
data 2
data 3
- - - - -
data 1200
Message 3
data 7
data 8
data 9
stream 2
message 4
data 10
data 11
data 12
eg 2
Stream 1
message 1
data 1-672
message 2
------------
Message 100
data 1-1200
Stream 2
Eg 3
stream 1 Message 1 data 1
stream 1 Message 1 data 2
stream 1 Message 1 data 3
stream 1 Message 1 data 4
stream 1 Message 1 ---------
stream 1 Message 1 data 672
stream 1 Message 2 data 1
stream 1 Message 2 data 2
stream 1 Message 2 --------
stream 1 Message 2 data 1200
stream 1 --------------- -------------
stream 1 Message 100 data 1
stream 1 Message 100 --------
stream 1 Message 100 data 900
stream 2 Message 1 data 1
stream 2 Message 1 data 2
etc.............
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
