Split text from captured text

[Sathish_Kumar_S]

Please help to do extract the values from below example texts

Text 1 :CA- - Plant 4001 - CoCode 4001

Need text available after CoCode

Expected output : 4001

Text 2 : [4001] HCS Inc USA

Value Inside [ * ] bracket

Expected output : 4001

Text 3 : [PIND] HMP Indirect Procurement Ariba

Value Inside [ * ] bracket

Expected output : PIND

[Palaniyappan (Forum Leader)]

@Sathish_Kumar_S

Text 1 :CA- - Plant 4001 - CoCode 4001

Need text available after CoCode

Expected output : 4001

Stroutput = Split(Strinput.ToString, “CoCode”)(1).ToString.Trim

@Sathish_Kumar_S

Text 2 : [4001] HCS Inc USA

Value Inside [ * ] bracket

Expected output : 4001

stroutput = System.Text.RegularExpressions.Regex.Match(Strinput.ToString, “\[(.*?)\]”).Groups(“1”).Value

@Sathish_Kumar_S

Text 3 : [PIND] HMP Indirect Procurement Ariba

Value Inside [ * ] bracket

Expected output : PIND

Same as above

Explanation

Cheers @Sathish_Kumar_S

[supriya117 (Supriya Allada)]

Hi @Sathish_Kumar_S

Matches1 = System.Text.RegularExpressions.Regex.Match(“CA- - Plant 4001 - CoCode 4001”, “(?<=CoCode\s+)\d+”).Value

Matches2 = System.Text.RegularExpressions.Regex.Match(" [4001] HCS Inc USA", “(?<=[)\d+”).Value

Matches2 = System.Text.RegularExpressions.Regex.Match(" [PIND] HMP Indirect Procurement Ariba", “(?<=[)[A-Z]+”).Value

[Anil_G (Anil Gorthi)]

@Sathish_Kumar_S

Please try these

Str.Split({"CoCode"},Stringsplitoptions.None)(1)

Str.Split({"[","]"},3,Stringsplitoptions.None)(1)

Or using regex

(?<=CoCode\s*).*

(?<=\[).*(?=\])

Cheers

[Palaniyappan (Forum Leader)]

Hope it’s clarified @Sathish_Kumar_S