How to split value in single quotes after specific string

Help Studio
, , , , , ,
1

hello,

i have below kind of errors

Cannot add user. ‘ABC’ does not exist, user is already a member of ‘Test_abc’ group
Cannot add user. ‘PQR’ does not exist

i only need value ABC and PQR from whole string.
“Cannot add user.” this is constant for each error.
help me on same to get only those values

2

@Mathkar_kunal Share dummy string value, if possible and expected output!

3

i have entioned

same like below one by on e error i am getting in loop

error 1] Cannot add user. ‘ABC’ does not exist, user is already a member of ‘Test_abc’ group
error 2] Cannot add user. ‘PQR’ does not exist

expected output

1] ABC
2] PQR

4

Hi @Mathkar_kunal

Try this

(?<=Cannot\s*add\s*user\.\s*‘)(\w+)

A regex pattern is being tested to extract user names in a text matching the format "Cannot add user '<username>'", with an example showing two matched usernames: "ABC" and "PQR". (Captioned by AI)
A regex pattern is being tested to extract user names in a text matching the format "Cannot add user '<username>'", with an example showing two matched usernames: "ABC" and "PQR". (Captioned by AI)1431×471 24.1 KB

Or

(?<=Cannot\s*add\s*user.*)([A-Z]+)

The image shows a regex pattern and test results; the pattern extracts single capital letter sequences after "Cannot add user," successfully matching 'ABC' and 'PQR' in the provided text. (Captioned by AI)
The image shows a regex pattern and test results; the pattern extracts single capital letter sequences after "Cannot add user," successfully matching 'ABC' and 'PQR' in the provided text. (Captioned by AI)1428×473 24.1 KB

This flowchart details a series of automation steps where an error message is assigned to an input variable, filtered for text using a regular expression, and then displayed in a message box. (Captioned by AI)
This flowchart details a series of automation steps where an error message is assigned to an input variable, filtered for text using a regular expression, and then displayed in a message box. (Captioned by AI)960×471 16.5 KB

System.Text.RegularExpressions.Regex.Match(Input,"(?<=Cannot\s*add\s*user.*)([A-Z]+)").Value

Regards,

5

The image shows a regular expression designed to capture segments of the string "Cannot add user" followed by a username within square brackets, which is being tested against strings indicating user errors in a test string field. (Captioned by AI)
The image shows a regular expression designed to capture segments of the string "Cannot add user" followed by a username within square brackets, which is being tested against strings indicating user errors in a test string field. (Captioned by AI)886×190 11.9 KB

(?<=Cannot add user. ['‘]).*?(?=['’])

we cannot rely on inverted single quotes like ‘ as it could be a copy paste issue but can handle defensive it

6

Okay @Mathkar_kunal

You are iterating through each string and you are getting error like: User does not exist.

Just create a empty list above your loop

myList = New List(Of String())

and put a try catch in for each activity in try block put all your activities, and in catch block use Append Item to Collection Activity.

At the end you will get all the Users which will throw an error!

Best regards,
Ajay Mishra

7

tried not working for Cannot add user. ‘ABC’ does not exist, user is already a member of ‘Test_abc’ group (giving output as T)this but worked for Cannot add user. ‘PQR’ does not exist

error 1] and error 2] i have added for understanding please dont consider that and it is not likke each user contains only 3 letters like abc it may differ like abcd or fdsfss

8

unfortunately feedback is not clear. please rephrase and let us know in detail

  • what was done
  • what is failling
  • used sample data
    Thanks
9

i have below kind of errors in loop one by one (errors are copied from webpage using extract data table)

Cannot add user. ‘ABC’ does not exist, user is already a member of ‘Test_abc’ group
Cannot add user. ‘PQRJYF’ does not exist
Cannot add user. ‘PQRD’ does not exist

need output like below
ABC
PQRJYF
PQRD

10

Pattern from above looks good:

The image depicts a text editor containing a specified regular expression to match user codes encapsulated in single quotes in a series of error messages shown in the test string section. (Captioned by AI)
The image depicts a text editor containing a specified regular expression to match user codes encapsulated in single quotes in a series of error messages shown in the test string section. (Captioned by AI)884×223 14.6 KB

also have a look here:
[CheatSheet] - System.Text.RegularExpressions | RegEx - News / Tutorials - UiPath Community Forum

[HowTo] LINQ (VB.Net) Learning Catalogue - Help / Something Else - UiPath Community Forum

11

image
image746×332 24.9 KB

image
image823×355 14.2 KB

i am using same expression then why output is like this

12

because you are using a toString / Message Box and it will not return the variable content but the datatype for this case. It is not a bug, it is the right behaviour from .Net.

inspections are done via debugging and e.g. debugging panels:
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

along e.g. with this statemtent:
String.Join(",", Result.Cast(Of Match).Select(Function (x) x.Value))

13

ok my bad one mistake from my end

image
image1231×517 27.6 KB

Cannot add user ‘abc’, user is already a member of ‘Test_Sanjeer’ (“.” is not there after user in such errors when it contains extra line as “already member of”

give me revised expression

14

its better to tell us all the samples and variations on the begin. Also, share text samples (SOP) always with us

The image shows a regular expression tool with a regex pattern and test strings, where specific words are highlighted to demonstrate matches and errors. (Captioned by AI)
The image shows a regular expression tool with a regex pattern and test strings, where specific words are highlighted to demonstrate matches and errors. (Captioned by AI)939×273 19.2 KB

(?<=Cannot add user\.? ['‘]).*?(?=['’])
15

yes,
thanks worked now

16

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