How we can take only value in Following string "11. Pound Sterling 103.30 99.85 "

" 11. Pound Sterling 103.30 99.85 "
How we can only value from above string
i wanted to extract 103.30 and 99.85 and store in separate variable

please Help me

Hi,

How about the following?

m = System.Text.RegularExpressions.Regex.Match(yourString,"(?<VALUE1>[\d.,]+)\s+(?<VALUE2>[\d.,]+)\s*$")

Then

m.Groups("VALUE1").Value
m.Groups("VALUE2").Value

note: m is System.Text.RegularExpressions.Match type

Sequence1.xaml (6.0 KB)

Regards,

Hi @Ajinya_jorwekar


Cheers!

Hi @Ajinya_jorwekar
Store the text in a string variable. Let’s assume this variable as str.
Then split the string variable on the basis of blank space and grab the last 2 indices of the resultant array.

arr = str.split(" ")
last_index = arr(arr.Length -1).ToString
second_last_index = arr(arr.Length - 2).ToString

Please mark this as the solution if it helps you.

Regards,

Hello,
Please Refer Below Screenshots


image

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.