Want to capture the part of the string.
I want a formula to capture a part of the string.
In a below line of strings i want to capture the part of text present within ( ) starting from right side of the string.
- File(/data/logs/smsp/dbm_cdr.log) Monitor on APP-SMSP02(TD-Comviva-A2PSMSC-192.168.4.53):CRITICA
- File(mor_cdr) monitor on SUFW03(TZ-Comviva-SUFW-172.27.55.166):NORMAL
- Ping Monitor on a2p-smsc01 (CG-Comviva-A2PSMSC-126.96.36.199):MINOR