Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.
parsing a string variable and get the numbers
I'm using visual basic .net in a aspx web forms application
If I have a string variable that looks like this that contains numbers and characters.
How do I save only the numbers in a different variable called Intvariable1 ?
Testvariable1 = "123|YYY"
sometimes the values in TestVariable1 will be this "123|YYY" or this "12|YYY" or this "3|YYY"
If I have a string variable that looks like this that contains numbers and characters.
How do I save only the numbers in a different variable called Intvariable1 ?
Testvariable1 = "123|YYY"
sometimes the values in TestVariable1 will be this "123|YYY" or this "12|YYY" or this "3|YYY"
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
If that is your value set, then I would split on the pipe and TryParse the splits as a numeric type; e.g. -
-saige-
Module Module1
Sub Main()
Dim values = New String() {"123|YYY", "12|YYY", "3|YYY"}
For Each value In values
Dim result As Integer
Dim selects = (From split In value.Split(New String() {"|"c}, StringSplitOptions.RemoveEmptyEntries)
Where Integer.TryParse(split, result)
Select split)
For Each selected In selects
Console.WriteLine($"{value} contains {selected}")
Next
Next
Console.ReadLine()
End Sub
End Module
On this link
https://stackoverflow.com/questions/13356018/get-only-numbers-from-string
I saw this example:
resultString = Regex.Match(subjectString,
if subjectstring = "28|NN"
then it returns 28
But it only works for positive numbers.
Because if subjectstring = "-1|NN"
then it returns 1
How do fix regex example to also work with negative numbers?
https://stackoverflow.com/questions/13356018/get-only-numbers-from-string
I saw this example:
resultString = Regex.Match(subjectString,
if subjectstring = "28|NN"
then it returns 28
But it only works for positive numbers.
Because if subjectstring = "-1|NN"
then it returns 1
How do fix regex example to also work with negative numbers?
My example works with both positive and negative numbers; e.g. -
-saige-
Module Module1
Sub Main()
Dim values = New String() {"123|YYY", "12|YYY", "3|YYY", "-3|YYY", "-12|YYY", "-123|YYY"}
For Each value In values
Dim result As Integer
Dim selects = (From split In value.Split(New String() {"|"c}, StringSplitOptions.RemoveEmptyEntries)
Where Integer.TryParse(split, result)
Select split)
For Each selected In selects
Console.WriteLine($"{value} contains {selected}")
Next
Next
Console.ReadLine()
End Sub
End Module
Premium Content
You need an Expert Office subscription to comment.Start Free Trial