cut it up

crmpicco · March 3rd, 2005, 08:48 AM

How do i cut this string:
ContractID:60 , Contract Code:BT5KL2N5
(coming from XML and going into a variable called 'contractline')

how to cut it up and put just the '60' into a variable in Visual Basic 6?

Picco

www.crmpicco.co.uk

marcostraf · March 3rd, 2005, 01:57 PM

find the positions of the first ":" and "," characters in the string, and then use the Mid$ function to extract the string between those two positions. (this will work if the number is indeed between the first : and , )
Marco