Need to extract only specific value

Help Activities
, ,
1

Hi everyone,

I have string sentence as below need to extract only few values

  1. R059 xx, vv
  2. Z20818 vv vv
  3. X1234 bb bb

I need a output as

R059;z20818; x1234

Please give me suggestion

Thanks

2

Hi @vaishali

Follow the same xaml from the below thread

Just change the Input in Assign activity and RegularExpressions in Find Matching Patterns activity as below:

Input = "R059 xx, vv
Z20818 vv vv
X1234 bb bb"

Pattern in Find Matching Patterns:
[A-Z0-9]+

Regards

3

@vaishali

You can try this in assign

StringArrayVariable = System.Text.Regularaexpressions.Regex.Matches(stringvariable,“[A-Za-z]\d+”).Cast(Of System.Text.Regularaexpressions.Regex.Match).Select(function(x) x.Value).ToArray`

IMG_7274
IMG_7274828×450 76.1 KB

Cheers

4

I tried to change the pattern it not working its extracting each and every word
Is there any other solution

5

I have tried this but am getting an error as below

IMG_20240517_223445
IMG_20240517_2234451920×1446 421 KB

6

Hi @vaishali

Can you share the screenshot once.

And can you try this regex once:
[A-Z0-9]+(?=\s+[a-z]+)

Regards

7

@vaishali

Can you opens imports panel and import those names spaces pelase

Cheers

8

I have tried this code in find matching pattern “[A-Za-z]\d+”) its working thanks

1 Like
9

Thanks for your input…

10

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