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
akila93
2
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.

@sangasangasanga Below regex is working fine. check it once.
(?<=Sys ).*?(?=\d{2}.[\w]{3}.\d{4}|,[\d]{2}[/][\d]{2})