How to extract the vauefrom string

[divyanancypaul.it]

Hi All

How do i extract the amount in given string and i need a value for $65/hr - $70/hr

Can anyone tell me how do i extract that?

[Shiva_Nikhil]

@divyanancypaul.it

can you please tell how your are getting the output format?

are you using get text activity ?

[divyanancypaul.it]

I used get text for overall, i need to extract the amount only

[Shiva_Nikhil]

@divyanancypaul.it

can you share the text which was fetched using get text activity?

so that we can help you

[rlgandu (Rajyalakshmi Gandu)]

@divyanancypaul.it

Output=System.Text.RegularExpressions.Regex.Match(GetTextInput,“$\d+/hr-$\d+/hr”).Value

If this is not give the correct value Please put the input string

[divyanancypaul.it]

IF there is an rate i need to extract so it may possible to get without rate so all information are dynamic

[rlgandu (Rajyalakshmi Gandu)]

@divyanancypaul.it

Put input and output of your Get text

[pikorpa (Piotr Kołakowski)]

Hey @divyanancypaul.it
you can use regex.
Try this:
\d+(\.\d+)?

BlankProcess92.zip (2.5 KB)

[Shiva_Nikhil]

@divyanancypaul.it

try this once

inputstr is your input variable

string.join("-",System.text.RegularExpressions.Regex.Matches(inputstr,"\$\d+").Cast(Of System.Text.RegularExpressions.Match).Select(Function(m) m.Value).ToArray())

gives output as
$60-$80