J John Dec 25, 2003 #1 Hi How can I break a string like "123 , 456" into two integers 123 and 456? Thanks Regards
H Herfried K. Wagner [MVP] Dec 25, 2003 #2 * "John said: How can I break a string like "123 , 456" into two integers 123 and 456? Click to expand... 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'.
* "John said: How can I break a string like "123 , 456" into two integers 123 and 456? Click to expand... 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'.
R Roger Renaud Dec 27, 2003 #3 Use INSTR function locate position of ",". Then extract each part with MID function. Or, try the SPLIT function to split in an array. Roger
Use INSTR function locate position of ",". Then extract each part with MID function. Or, try the SPLIT function to split in an array. Roger
