How to cast String type to Integer?

Help
1

Hi everyone,
Do you know how to cast data containing letters to integer, like N90 to 90…I tried Cint() and Integer.Parse, but they neither worked.

Thanks all.

2

Hi @sxintian,

You can use isnumeric to get the numbers in the string.

3

Hi @sxintian Check this workflow Main.xaml (5.2 KB)

Use Regular Expressions for parsing:
System.Text.RegularExpressions.Regex.Replace(str, “[^0-9]”, " ")

3 Likes
5

I think this function is for determining whether the variable consists of numbers. If not, it will return false. But it can also solve my problem. Thanks for your help. :slight_smile:

6

I’ve run this workflow and it worked!! Thank you, Anand! :slight_smile:

7

You can try this…

Loop through every character of the string and if it is numeric, then do the required:

Here is the code

           If IsNumeric(num) Then num = -------------------