Extract four digit number from the sentence

[vaishali]

Hi Team,

date code charge
05/14/2024 1234 Tb test bbb
05/14/2024 g123 aa bbb uuu
05/14/2024 5678 yyy uuu iii 32

From the above text i need to extract only 1234 , g123, 5678

Here date is dynamic its not static one

Any suggestions? To the code alone

Thanks

[vrdabberu (Varunraj Dabberu)]

Hi @vaishali

Try this:

(?<=\d+\/\d+\/\d+\s+)[a-z0-9]+

Regards

[vaishali]

I have tried this but i am able to extract only first line code not other line

[vrdabberu (Varunraj Dabberu)]

Hi @vaishali

Can you share the screenshot of the flow.

Regards

[postwick (Paul Ostwick)]

You need to use System.Text.RegularExpressions.RegEx.Matches not .Match

.Matches gives you an array of all the matching values.

[vrdabberu (Varunraj Dabberu)]

Hi @vaishali

Check the below workflow:
Sequence6.xaml (7.8 KB)

Output:

Regards

[vaishali]

Thanks for sharing xaml

[vrdabberu (Varunraj Dabberu)]

Glad to have helped @vaishali

Happy Automation!!