I want to extract data from text which comes from each row

[vinjam_likitha]

Hi Team,

Input
[STEP 4B: SOFTWARE INSTALLATION] ;Lohezic, Maélène

from the above Input i need to extract “4B”

please help me with the solution

Thanks in advance
Likitha

[akwar (Ankit Kunturwar)]

Hello Vinjam,

You can do it using String manipulation or you can use Regex Also :
Please try following expresiion
(?<=(STEP\s{0,}))\w+

Tested on

.NET Regex Tester - Regex Storm

Hope it helps
Regards
Ankit

[Anil_G (Anil Gorthi)]

@vinjam_likitha

Try this

System.Text.RegularExpressions.Regex.Match(str,"(?<=STEP).*(?=:)").Value.Trim

Cheers

[MdFuadHasan]

Hi @vinjam_likitha

For String manipulation approach, you can try this:

Assign StringVar = “[STEP 4B: SOFTWARE INSTALLATION] ;Lohezic, Maélène”

(stringVar.Split(“STEP”)(1)).Split(“:”)(0).Trim

Cheers

[vinjam_likitha]

Thanks for the solution