Extract a number from string

[pravin_bindage]

i have string → 00000000000000000000000000000000000000000013584500000000000000000N0000000000135845

i wants to extract on 135845 from this string
every time the number changes it my be 5 digit or 8 or anything
like this → 0000000000000000000000000000000000000001800000000000000000N0000000000000018 from this string i want 18

[Sudharsan_Ka]

HI @pravin_bindage

Try this expression

System.Text.RegularExpressions.Regex.Match(YourString,"[1-9]+$").Tostring.Trim

Regards
Sudharsan

[Steven_McKeering]

@pravin_bindage

00000000000000000000000000000000000000000013584500000000000000000N0000000000135845

Hey @pravin_bindage

Take a look at this updated pattern:

.NET Regex Tester - Regex Storm

Cheers

Steve

[anon87560229]

Hi

It’s as simple as this

Use a expression like this

str_output = str_input.ToString.TrimStart(“0”c).ToString

Where str_output is of type string variable

to remove zero after no use
text = your_Variable

use this text.Remove(text.Length-1)

Cheers

[Sudharsan_Ka]

Can you share the data that is in the file variable? @pravin_bindage

[pravin_bindage]

Sorry brother that solution is working thanks

[pravin_bindage]

But if in some cases no like this 107856 then what can i do?

[pravin_bindage]

@Sudharsan_Ka @anon87560229 in some cases number like this 1073569 then what can we do?

[Sudharsan_Ka]

Check with this expression @pravin_bindage

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=0)[1-9]+\d+$").Tostring.Trim

[pravin_bindage]

again same problem null result

[Yoichi]

Hi,

Can you try the following?

Decimal.Parse(System.Text.RegularExpressions.Regex.Match(yourString,"\d+$").Value).ToString

Regards,

[Sudharsan_Ka]

Can you show the expression you written? @pravin_bindage

[pravin_bindage]

System.Text.RegularExpressions.Regex.Match(Text1,“(?<=0)[1-9]+\d+$”).Tostring.Trim

[pravin_bindage]

input string format problem

[pravin_bindage]

format is string

[Yoichi]

Hi,

There might be extra white space at the end of the string.
Can you try to use Trim method as the following?

Decimal.Parse(System.Text.RegularExpressions.Regex.Match(yourString.Trim,"\d+$").Value).ToString

Regards,

[pravin_bindage]

yes now its working