How to get the required output from given input using regex or trim or anything? Please help

[anjasing (Anjali)]

inputVariable = Program : ZABC_PQ_STP_DM ( ZABC_PQ_STP_DM )

required output:
outputVariable = ZABC_PQ_STP_DM

[Steven_McKeering]

@anjasing

ZABC_PQ_STP_DM ( ZABC_PQ_STP_DM )

Hi @anjasing

Take a look at these options:
Option 1
Option 2
Option 3

If you want to learn Regex Check out my Regex MegaPost

Can you expand upon the pattern of text. What is consistent?

Cheers

Steve

EDIT: I had the wrong sample Input

Alright, logging off for today

[Gokul001 (Gokul Balaji)]

Hi @anjasing

Try this regex expression

System.Text.RegularExpressions.Regex.Match("InputStr","(?<=Program\s:\s)(\S+)").Tostring.Trim

Regards
Gokul

[supermanPunch (Arpan)]

@anjasing

Program : ZABC_PQ_STP_DM ( ZABC_PQ_STP_DM )

Hi @anjasing ,

Using String Split :

Split(Split(inputVariable,":")(1),"(")(0).ToString.Trim

[ashwin.ashok ((TheCodingTheory))]

Hi @anjasing ,

It depends - are you interested in retrieving the text present within the Brackets or the text preceding the brackets?

I’ve included the solution to both →

System.Text.RegularExpressions.Regex.Match(inputVariable,"(?<=\:\s)(.*?)(?=\s?\()").Value

System.Text.RegularExpressions.Regex.Match(inputVariable,"(?<=\(\s)(.*?)(?=\s?\))").Value

Do let us know if that works.

Kind Regards,
Ashwin A.K

[anjasing (Anjali)]

Hi All, Thank you so much for your quick replies.

[anjasing (Anjali)]

Thank you so much for the links…that are great!