Specific String Extraction

[prerna.gupta]

Team, Need to extract required string where Input can be vary but desired output is required.

Input1 = Showing 1-20 of 21 results
Output = 21

Input2 = Showing 1-20 of 10983 results
Output = 10983

Note It should be case sensitive (ie both capital and small alphabets should work).

Thanks in advance

[B_H_Akshatha_Pai]

You can use string.split(" "c) and then get the number based on its index

or use regex

Regards

[prerna.gupta]

Index is not constant

[B_H_Akshatha_Pai]

@prerna.gupta

Regards

[ppr (Peter)]

strtext = Your Text
strPattern = "(?<=\d+ of )\d+"

strValue = System.Text.RegularExpressions.Regex.Match(strText, strPattern).Value

[Gokul001 (Gokul Balaji)]

Hi @prerna.gupta

You can try with Regex expression

System.Text.RegularExpressions.Regex.Match(YourString,"\d+(?=\sresults)").Tostring

Regards
Gokul

[prerna.gupta]

If we need to further verify strValue > 10K then do we need data type changes ? As string wont support double data type

[ppr (Peter)]

focus on this topic scoped to 1 Topic = 1 case on extraction.

For need on conversion just open a new topic and share with us all samples, that you are expecting. Thanks