Please help me on the regex

[Marian_B (Marian)]

Hello everyone

I need to extract the value from the input string

Input - Data is private total - 54545.58
Output - 54545.58

[Gokul001 (Gokul Balaji)]

Hi @Marian_B

Use Assign activity
LHS - Create an variable
RHS - System.Text.RegularExpressions.Regex.Match(“Input string”,“(?<=total\s-)\s+(\S+)”).Tostring.Trim

regex101: build, test, and debug regex

Regards
Gokul

[lakshman (Ganta lakshman)]

@Marian_B

Try below Regular expression.

 System.Text.RegularExpressions.Regex.Match(“Input string”,"\d+.\d+").Value

[THIRU_NANI (NaNi)]

Hi!

Try this out:

System.Text.RegularExpressions.Regex.Match(“Input string”,"(?<=total - ).\S+)").Value

regex101: build, test, and debug regex

Output:-

Regards,
NaNi

[pravin_calvin (pravin kumar)]

Hi @Marian_B

We can also try with split method!

Split(inputString,“-”)(1) will result your expectation!

Regards

[Marian_B (Marian)]

Its working. Thanks you for looking into it @Gokul001 @lakshman @THIRU_NANI @pravin_calvin