Need to extract data from text

[vinjam_likitha]

Hi team,

Need to extract text:
Input:
[STEP 1B: REVIEW];Miyoshi, Mitsuharu;Wakayama, Tetsuya;Smith, Alex

from this i need STEP 1B as output

Output-- STEP 1B

Thanks in Advance
Likitha

[Gokul001 (Gokul Balaji)]

Hi @vinjam_likitha

You can try with Regex expression

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=\[)\S.*(?=:)").Tostring

Regards
Gokul

[ppr (Peter Preuss)]

Cross reference:

Extracting value from text

[grafik] [grafik] System.Text.RegularExpressions.Regex.Match(YourTextVar, "(?<=\[).*(?=\])").Value

[vinjam_likitha]

Hi

Some minor change

Input:
[STEP 1B: REVIEW];Miyoshi, Mitsuharu;Wakayama, Tetsuya;Smith, Alex
[STEP 2: DOCUMENTATION & BUDGET];Scadden, Sydney

I need to extract only numbers 1 for first input and 2 from second input those are just examples which i get from excel rows.

Thanks
Likitha

[Gokul001 (Gokul Balaji)]

Hi @vinjam_likitha

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=\[STEP\s)\d").Tostring

Regards,