string to integer

[John]

Hi

How can I break a string like "123 , 456" into two integers 123 and 456?

Thanks

Regards

 

[Herfried K. Wagner [MVP]]

How can I break a string like "123 , 456" into two integers 123 and 456?

Have a look at the 'Strings.Split' method or the string's 'Split'
method. These methods will give you an array containing the two
numbers. Then you can convert them to integers by using
'Integer.Parse'.

 

[Roger Renaud]

Use INSTR function locate position of ",". Then extract each part with MID
function. Or, try the SPLIT function to split in an array.

Roger