Text Extraction : String Manipulation/Regex

[vkshambhu (vinod)]

Hi All,

Can anyone advise on best way to extract the highlighted text from screenshot below.

Thanks in Advance.

[prasath17 (Guru)]

@vkshambhu …will this follow the same syntax?

I.e 3 letter alphabets / 3 letter alphabets / 2 digits numbers space alphabet number ?

[prasath17 (Guru)]

@vkshambhu - Please try this out

RegEx Pattern: \S+/\d+\s\S+

Please refer this Regex mega post for your learnings…

[vkshambhu (vinod)]

Thanks for your response and sharing the regex post, seems to be quite useful.

Regex provided selects only GGH/HTY/76 A7 and when i use \S+/\d+\s*\S+ it returns only BDF/GER/12 G5

Works fine in tester though. Just when i use write line it do not print whole set.

[prasath17 (Guru)]

@vkshambhu - Could you please share your workflow screen shot?..

[vkshambhu (vinod)]

Sure ,

System.Text.RegularExpressions.Regex.Match(strInput,"\S+/\d+\s\S+").Value.Trim
System.Text.RegularExpressions.Regex.Match(strInput,"\S+/\d+\s*\S+").Value

Attaching .xaml for referenceregexBetweenLabel.xaml (5.1 KB)

[prasath17 (Guru)]

@vkshambhu - Please see my output…

.

XAML:

I have used IsMatches Activty and used that output in the For Each Loop

[vkshambhu (vinod)]

Thank you. Can you pls upload the .xaml as well.

[prasath17 (Guru)]

@vkshambhu - Here you go… Regex_VKS.zip (35.1 KB)