Regex to find the 2nd occurance

[LauraMM (Laura)]

Maybe this is simple.

Input: “Total 3,12 4,35 6,84”

I want my match to be 4,35.

Challenge: The number is random, so next time it will e.g. be 4,35.
Challenge: The number of spaces between the numbers differ from time to time

[NIVED_NAMBIAR (NIVED N)]

Hi @LauraMM

I could not understand ur query well

Can u elaborate please

[Steven_McKeering]

Hello

I think I understand your scenario.

Try this pattern:
(?<=Total\s+\d+,\d+\s+)\d+,\d+

It will match the second pair (eg 4,56) of digits regardless of length of spaces between digits or length of digits.

Hopefully this helps

If you want to Learn Regex - check out my Regex MegaPost

Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more

THE PURPOSE OF THIS POST IS TO HELP NEW REGEX USERS If you need help with Regex be sure to provide in your post, a Sample, the Output and the Pattern (as much as you know). CONTENTS: Section : I need a Regex Pattern ASAP! - My first Regex Post Section : Regex samples that you can use! Section : I need help applying regex in UiPath Section : Regex Matches and Groups Section : Le…