Re: Function help by axtens
axtens
Sat Aug 12 03:27:09 CDT 2006
G'day Sunny
If the numbers are on the same line as the names, you could try
something like
aData = Split( cData, " ", 2 )
and then aData( 1 ) will contain the number and aData( 2 ) the name.
If the numbers are on a separate line, you could try keeping a count of
the lines, and every time the line number is odd, that's the number,
and when even, that's the name.
Kind regards,
Bruce.
Sunny wrote:
> Hi,
>
> I have a stream which returns a value as shown below,
>
> 1190
> Chris Grove
> 1058
> GEORGE EVANS
> 1231
> Susan D Elowson
>
> How do I return just the Numbers preceding the names?
>
> Any help is sincerely appreciated.
>
> Thx,
>
> Sunny