Text Extraction : String Manipulation/Regex

Help Activities
, ,
1

Hi All,

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

image

Thanks in Advance.

2

@vkshambhu …will this follow the same syntax?

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

3

@vkshambhu - Please try this out

image
image552×612 56 KB

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

Please refer this Regex mega post for your learnings…

4

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.

image
image776×355 20.3 KB

5

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

6

Sure ,

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

image
image1228×705 37.1 KB

Attaching .xaml for referenceregexBetweenLabel.xaml (5.1 KB)

7

@vkshambhu - Please see my output…

image .

XAML:

image
image442×668 13.2 KB

image
image1376×630 25.3 KB

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

8

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

9

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