How to extract numbers after every static word

[vnsatyasunil]

For eg I have input FROM GET FULL TEXT
AFD7,876SIGNCOPY675MPD9,877SVC7,765APE20,789
in this section names are AFD,SIGN COPY,MPD,SVC,APE
I need to extract number counts after these names
Please guide anyone?

[Shiva_Nikhil]

system.text.regularexpression.regex.maches(variable,“[0-9,]+”).count

[Nguyen_Van_Luong1 (Nguyễn Văn Lương (Albert Nguyễn))]

Hi @vnsatyasunil ,
string b= System.Text.RegularExpressions.Regex.Replace(“string_Variable”,“\D”,“”)
regards,
LNV

[rlgandu]

@vnsatyasunil
Array_str=Str.Split(“,“c)
For each
InputString=System.Text.RegularExpressions.Regex.Match(currentItem,”[A-Z]+”).Value
Assign:InputString.Length--------------->This will give the length

[Moulika_Kaviti]

@vnsatyasunil

AFD7,876SIGNCOPY675MPD9,877SVC7,765APE20,789

can you please look into this

[lrtetala (Lakshman Reddy)]

Hi @vnsatyasunil

\d+

[vnsatyasunil]

getting count but not getting counts i.e numbers

[lrtetala (Lakshman Reddy)]

@vnsatyasunil

Try this

\d+\,?\d+

[vnsatyasunil]

Is this the expression?
system.text.regular expressions.regex.matches(variablename,“(\d+,?\d+)”.tostring

[lrtetala (Lakshman Reddy)]

@vnsatyasunil

Extracting numbers from the input text

[Shiva_Nikhil]

Hi @vnsatyasunil

Assign the syntax to matchCollection variable

Use matchcollectionvaraible(index).length gives you the length of each

[lrtetala (Lakshman Reddy)]

@vnsatyasunil

[Moulika_Kaviti]

Assign activity:
input=AFD7,876SIGNCOPY675MPD9,877SVC7,765APE20,789

Take again Assign activity
output=system.text.Regular Expressions.Regex.Matches(input,“(?<=[A_Z])[0-9.,]+”).value

[mkankatala (Mahesh Kankatala)]

Hi @vnsatyasunil

You can use the below regular expression to extract the required output

System.Text.RegularExpressions.Regex.Matches(yourstringinput.ToString,“((?<=\w+)[\d,]+)”)

Hope it helps!!