Extract a number from string 1

[emergencyplan]

Hello everyone,

I've looked but cannot find.....I have a string of numbers in the following format 10,12,13,200. In this example I would like to use the 13 .i.e. the third integer in the string. Also, this integer could range from 0-15000 and therefore I need to be flexible when extracting the string.

Any help gratefully recieved,

thanks

Laurence

 

[johnwm]

Look up the Split() function - does just what you want

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[johnwm]

Sorry - hit submit too quickly:

myArray = Split(myList,",&quot
myThirdNum = myArray(2)

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[mattKnight]

>myThirdNum = myArray(2)

Just for clarity...

shouldn't that be

myintThirdNum = cint(myArray(2))

Take Care

Matt
If at first you don't succeed, skydiving is not for you.

 

[MakeItSo]

OK, if the max for this number is 15.000, an Integer variable will still do it (goes to 32k):

Dim i,x,MyVal as Integer
Dim helper as String
helper=YourString 'don't want to overwrite your String!
For i=1 to 2
x=Instr(1,helper,",&quot
helper=Right(helper,Len(helper)-x)
Next i
x=Instr(1,helper,",&quot
helper=Left(helper,x-1)
MyVal=Cint(helper)

Does that do what you need?

MakeItSo



Andreas Galambos
EDP / Technical Support Specialist
Bowne Global Solutions Wuppertal, Germany
(andreas.galambos@bowneglobal.de)
HP:

http://home.arcor.de/andygalambos