Getting information out of a string

[Thomas]

Hi!

I need help getting some information out of a text string.
The text string contains different id-numbers together with a minute
specification.
Example:
Textstring = "125(58),254(65),302(69),324(79)"

Now, the numbers 125, 254, 302, 324 are id-numbers of player names.
The numbers within () is which minute the player (id in front of it)
made a certain action.

Can I in some way loop this and add it to my database?

I have added it without looping but it´s a lot of writing and it would
be good to have it more automated.

Can anyone help me?

 

[Bob Barrows [MVP]]

Hi!

I need help getting some information out of a text string.
The text string contains different id-numbers together with a minute
specification.
Example:
Textstring = "125(58),254(65),302(69),324(79)"

Now, the numbers 125, 254, 302, 324 are id-numbers of player names.
The numbers within () is which minute the player (id in front of it)
made a certain action.

Can I in some way loop this and add it to my database?

I have added it without looping but it´s a lot of writing and it would
be good to have it more automated.

Can anyone help me?

dim arPlayers,arPlayer,iID, iMinutes, i

arPlayers=split(textstring,",")
for i = 0 to ubound(arPlayers)
arPlayer = split(arPlayers(i),"(")
iID = CInt(arPlayer(0)
iMinutes=CInt(Left(arPlayer(1),len(arPlayer(1)) - 1))
'insert the id and minutes into your database here
next

HTH,
Bob Barrows