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

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

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

Hope it helps
Regards
Ankit

@vinjam_likitha

Try this

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

Cheers

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

Thanks for the solution

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.