Regex - help with my use case 2

Regex usex: (?<=Sys ).*

E.g.
G Operating Sys (OS8 MS Win Svr 2008R2 EE) 01 Apr 2018 to 30 Apr 2018 57 .90
G Operating Sys (Linux Redhat, Ent 64 bit (small 01 Apr 2018 to 30 Apr 2018 64 .22
instance))
G Operating Sys (OS10 Linux Redhat, Ent 64-bit 05 Apr 2018 to 30 Apr 2018 (Prorated Charge) 55 .66
(small instance))
G Operating Sys (OS10 Linux Redhat, Ent 64-bit 19 Apr 2018 to 30 Apr 2018 (Prorated Charge) 25 .69
(small instance)) S10368-AAJ

Expected Outcome:
(OS8 MS Win Svr 2008R2 EE)
(Linux Redhat, Ent 64 bit (small
(OS10 Linux Redhat, Ent 64-bit
(OS10 Linux Redhat, Ent 64-bit

I need the words after System but before the date. How can I do it?

Thank you xoxo

Hi @sangasangasanga,

Use the below pattern

(?<=Sys ).*?(?=\d{2}.[a-zA-Z]{3}.\d{4})

2 Likes

Hi @akila93. Thanks for your fast reply it works but not for all.
image

@sangasangasanga Below regex is working fine. check it once.

(?<=Sys ).*?(?=\d{2}.[\w]{3}.\d{4}|,[\d]{2}[/][\d]{2})