I would like to get number from a string eg: My123number gives 123 Similarly varchar(32) gives 32 etc
Thanks in Advance.
See Question&Answers more detail:osI would like to get number from a string eg: My123number gives 123 Similarly varchar(32) gives 32 etc
Thanks in Advance.
See Question&Answers more detail:osIf there is going to be only one number buried in the string, and it is going to be an integer, then something like this:
int n;
string s = "My123Number";
if (int.TryParse (new string (s.Where (a => Char.IsDigit (a)).ToArray ()), out n)) {
Console.WriteLine ("The number is {0}", n);
}
To explain: s.Where (a => Char.IsDigit (a)).ToArray ()
extracts only the digits from the original string into an array of char. Then, new string
converts that to a string and finally int.TryParse
converts that to an integer.