Regex the Extraction of checkbox enabled information

Help Activities
,
1

Hi Automation guys,
I want to get the information only on the checkbox-checked values from the list. Could you please share the regex expressions to resolve the task?
☐ 134091 ☒ 134092 ☐ 134093 ☒OK ☒ OK

Expected result: 134092 OK OK

Thanks!
Happy Automation

3

Hi @Iswarya_P1

Use the below regular expression,

- Assign -> Input = "☐ 134091 ☒ 134092 ☐ 134093 ☒OK ☒ OK"
- Assign -> Output = String.Join(" ",System.Text.RegularExpressions.Regex.Matches(Input,"(?<=☒\s?)(\d+|\w+)"))

image

Check the below workflow for better understanding,

image
image760×460 16.1 KB

Hope it helps!!

4

@Iswarya_P1

image

Use Find Matching Pattern Activity

For Each loop

OutputResult=String.Join(“,”, outputString, item.ToString())

Hope it helps

5

Hi @Iswarya_P1

Can you try the below

(?<=☒).*(?=☐)|(?<=☒).*(?= ☒)|(?<=☒ ).*(?=)

image
image818×564 15.2 KB

String.Join(" ", System.Text.RegularExpressions.Regex.Matches(Input,"(?<=☒).*(?=☐)|(?<=☒).*(?= ☒)|(?<=☒ ).*(?=)"))

image
image838×352 16.6 KB

Cheers!!

6

when we can rely on the textual presence of: ☐ ☒

A regex could look like this
grafik

we would trim the value

7

@Iswarya_P1 just curious to know wheather this text ☐ 134091 ☒ 134092 ☐ 134093 ☒OK ☒ OK Looks like this itself or the check and uncheck is image based selection