I’m currently working on an issue, which needs to get specific number in a string.
The string would be like: overall 54 records, 3 pages in total.
I need to get the “3” out of this sentence. However this expression is not working: integer.parse(right(“page”,5))
Do you know how to deal with this issue? Thanks a lot.
You can try this
Hope the below expression would help you resolve this
Use a assign activity like this
Str_value = System.Text.RegularExpressions.Regex.Match(str,”\d+(?=\spages|pages)”).Value
Where str_value is a string variable
The reason why ur expression was not working is
this expression attempts to extract the rightmost 5 characters of the string “page” (which will be “page” itself), and then convert them to an integer. Since “page” cannot be parsed as an integer, this expression will throw a
FormatException at runtime.
Split(Split("overall 54 records, 3 pages in total."," pages")(0),"records, ")(1)
Really appreciate your answer, it’s working.
Glad it got resolved @Paddi
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.