Need to remove string from sentence

[shruthi_arali]

Hi,

I need to extract “4500002003” from the sentence “Standard PO created under the number 4500002003”

Kindly help me.

[ppr (Peter Preuss)]

@shruthi_arali

Standard PO created under the number 4500002003

Quick Dirty:

Assign Activity:
strCleansed =
System.Text.RegularExpressions.Regex.Replace(strInVar, "\d+","")

[shruthi_arali]

I need to extract the number also separately

[ppr (Peter Preuss)]

then regex and groups will help

[CheatSheet] - System.Text.RegularExpressions | RegEx

This CheatSheet introduces the basic use of regex functions. With further examples also special cases are presented. Introduction From the namespace System.Text.RegularExpressions following methods are offered: Regex.Match Regex.Matches Regex.isMatch Regex.Replace Regex.Split A simple usage for example would look like this: [grafik] Recommendation: add System.Text.RegularExpressions to the imports: [grafik] it allows to use the shortened statement, as the namespace part can be ommited…

[neha.upase]

Hi,

You can use below expression

System.Text.RegularExpressions.Regex.Match(yourInputString, “\b\d+\b”).Value

[abhishekkr28july (Abhishek)]

You can use split function.
Split the string with space and then extract last index of the array. In this case index will be 6.

For ex:
Var = Standard PO created under the number 4500002003

Assign

Var_Arr= var.split(" ")
Var = Var_Arr(6).tostring