The beginning character ^ of REGEX does not work in Matches Activity

Dear Experts,

I have use case where the beginning character ^ of REGEX does not work in Matches Activity, where as the same was working regex101.

^\d{2}/\d{4}\s+(\d+)

12.02.2021 390 44836
08/2021 390 45226
12/2021 390 45616
13/2021 390 46006
14/2021 390 46396
15/2021 390 46786
16/2021 390 47176
17/2021 1560 48736
18-21/2021 4680 53416
22-26/2021 5850 59266
27-30/2021 4680 63946
31-34/2021 2340 66286

I need to extract only those which are marked in bold, however when I put this expression in Matches, nothing returns and if I remove the ^ then I am getting all the records which are listed there.

image

Your inputs would be highly appreciated.

Hi,

Can you try to check Mulitiline option as the following?

img20211114-7

rege101 is set it on default.

Regards,

Hell @Yoichi ,

Thank you

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.