How to get all occurrences using regex pattern

[mohamedalthaf]

Hi Guys,

when I use the above regex pattern in Find Matching Patterns activity, it is able to recognise all the occurences but when I pass this in for each loop it is only the giving the first occurence as output (ABC Bank SAR 0.00 100.00).
But I need both occurences in output.

The required output is : 1. ABC Bank SAR 0.00 100.00 2. XYZ Bank SAR 0.00 6479.00

How to fine tune this?

Thanks!!

[ashokkarale]

@mohamedalthaf,

Check in Locals/Immediate panel while debugging that what’s the value of Split_Lines. It should have groups.

Thanks,
Ashok

[mkankatala (Mahesh Kankatala)]

Hi @mohamedalthaf

Your regular expressions not working, try the below regular expressions in the Find Matching Patterns activity,

[A-Za-z\s]+\d+\.?\d+\s+\d+\.?\d+

Check the below image for better understanding,

Check the below workflow,

Hope it helps!!

[Yoichi]

Hi,

Can you share content of input string (if possible, as file using WtiteTextFile activity)?
It may not be same with what expected.

Regards,

[mohamedalthaf]

@mkankatala it’s working. Thanks!!

[mkankatala (Mahesh Kankatala)]

It’s my pleasure… @mohamedalthaf

Happy Automation!!