Need to extract data from text

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

Hi @vinjam_likitha

You can try with Regex expression

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

image

Regards
Gokul

Cross reference:

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

Hi @vinjam_likitha

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

image

Regards,