Regex pattern to remove special character

Help Studio
1

Hello,

I need to remove the special character from the string.
WQ#1234567
WQ 1234567
WQ/1234567
WQ-12345678
Q#1234567
Q 1234567
Q/1234567
Q-12345678

The actual output should be like wq1234567 and q1234567
Wq followed by 7digit and q followed by 7 digit.

Please help

2

Regex.Replace(input, “(?i)(WQ|Q)[#\s/-]*(\d{7})”, Function(m) m.Groups(1).Value.ToLower() & m.Groups(2).Value)

3

Hey @sharu_priya try this code

The image shows a UiPath workflow with a Write Line activity using the Expression Editor to replace non-alphanumeric characters in a string variable "yourValue" with an empty string using Regex. (Captioned by AI)
The image shows a UiPath workflow with a Write Line activity using the Expression Editor to replace non-alphanumeric characters in a string variable "yourValue" with an empty string using Regex. (Captioned by AI)933Ă—516 25.6 KB

The image shows a UiPath workflow with an Expression Editor window demonstrating the use of Regular Expressions to remove non-alphanumeric characters from a string stored in a variable. (Captioned by AI)
The image shows a UiPath workflow with an Expression Editor window demonstrating the use of Regular Expressions to remove non-alphanumeric characters from a string stored in a variable. (Captioned by AI)968Ă—491 28.8 KB

as you can see in the image it will remove special character

System.Text.RegularExpressions.Regex.Replace( yourValue, “[^a-zA-Z0-9]”, “”)

cheers happy automation

4

Hey @sharu_priya
Try this approach:
BlankProcess13.zip (3.0 KB)

This image shows a sequence of programming assignments and a loop in a software automation tool, where an input string "WQ#1234567" is split into an array of strings using new line characters as delimiters, with empty entries removed. (Captioned by AI)
This image shows a sequence of programming assignments and a loop in a software automation tool, where an input string "WQ#1234567" is split into an array of strings using new line characters as delimiters, with empty entries removed. (Captioned by AI)730Ă—496 47.7 KB

This image shows a portion of a programming workflow where a string is being cleaned to remove any non-alphanumeric characters and converted to lowercase using a regular expression, and the result is being used in a conditional statement. (Captioned by AI)
This image shows a portion of a programming workflow where a string is being cleaned to remove any non-alphanumeric characters and converted to lowercase using a regular expression, and the result is being used in a conditional statement. (Captioned by AI)842Ă—505 52.2 KB

The image shows a conditional block in a visual programming interface where a regular expression is used to check if a string matches a specific pattern before appending it to a collection. (Captioned by AI)
The image shows a conditional block in a visual programming interface where a regular expression is used to check if a string matches a specific pattern before appending it to a collection. (Captioned by AI)783Ă—500 47.7 KB

The image shows the user interface of a software development environment with an active debugging session and a table listing various variable names and their attributes. (Captioned by AI)
The image shows the user interface of a software development environment with an active debugging session and a table listing various variable names and their attributes. (Captioned by AI)1473Ă—443 89.3 KB

5

Assign activity:
strCleansed =

System.Text.RegularExpressions.Regex.Replace(yourStringVar.Trim(), "(?<=^W?Q)[#\s\/\-](?=\d{7})", "")
6

Main.xaml (7.7 KB)

This image depicts a sequence in UiPath Studio where a string is being modified using regular expressions and the result is logged. (Captioned by AI)
This image depicts a sequence in UiPath Studio where a string is being modified using regular expressions and the result is logged. (Captioned by AI)1056Ă—785 24.3 KB
n
Use above sequence.
Don’t forget to Import System.Text.RegularExpression namespace

7

will try and let you know… Thanks much

8

@adi.mehare @pikorpa @singh_sumit @ppr

Thank you so much for all your valuable comments.

I need this in a single regular expression because one of all this formats will be there in the mail.

So bot should extract Wq1234567… format can any one of these and moreover i will be placing this regex in asset.

To be short, all this format should work in one regular expression.

(?i)\b(WQ|Q)[-\s]?\d{7,8}\b- this pattern extracts all except (- and / i.e WQ-12345678, WQ/1234567)

Please help

9

this should take care of your all formats, you don’t need any different formates

10

@sharu_priya basically this regex is used to remove special character from your value so if the value changed it still working for you. so try it on with multiple values . this should take care of all formats.

cheers Happy Automation

11

Hey @sharu_priya
Please check this solution:
BlankProcess13 (2).zip (2.6 KB)

The image shows a UiPath workflow with Debug output, where a regular expression pattern is used to process and extract strings in a sequence, and the results are displayed in the output panel. (Captioned by AI)
The image shows a UiPath workflow with Debug output, where a regular expression pattern is used to process and extract strings in a sequence, and the results are displayed in the output panel. (Captioned by AI)1473Ă—545 121 KB

12

@singh_sumit @pikorpa @adi.mehare @ppr

The requirement is little different:

I need to get only WQ3153682 from the below text.

" Freight Pickup: 232613 LTL Less-Than-Truckload (Dry Van) from Langley Township, BC to Sumner, WA Caller: Shipper: Consignee: Caller is the: Shipper Billing is: Prepaid (Shipper Will Pay) Payment by: CSA Shipping Account Company Name: Panefri North America Contact Name: ABC Phone: 0000000000 Associated CSA Quote Number: WQ3153682 Your Email: orders@panefri.commailto:orders@ABC.com Confirm Email: orders@ABC.com Company Name: ABC Contact Name:ABC”

This is the mail body.

So in any of the mail body wq… contains means i need to extract only that.

so that wq will be in different formats like i mentioned in the query.

Little tricky so please help me

I am using find matching pattern activities… in that text in search property this string will be there which is extracted from mail body.

So i have to give that pattern which extracts wq…

This image shows a screenshot of a UiPath workflow, specifically focusing on the "Find Matching Patterns" activity configured with a regular expression pattern for text matching. (Captioned by AI)
This image shows a screenshot of a UiPath workflow, specifically focusing on the "Find Matching Patterns" activity configured with a regular expression pattern for text matching. (Captioned by AI)1275Ă—544 30.9 KB

13

Does the mail body always contain 'Quote Number: ’ followed by the WQ/Q extraction you need? Then you could just use (?<=Quote Number:\s)[A-Za-z0-9]+ I think.

14

no… if the wq contains any special char… it should not take that special charactrs.

it should fetch only wq or q followed by 7 or 8 digits

15

Yes, sorry you’re right. I’m not sure if there’s a regex way to do this. Maybe you need a extra step to remove the special characters. Hopefully someone else has the solution for you.

16

@sharu_priya
we suggest that you have a closer look at regex
[CheatSheet] - System.Text.RegularExpressions | RegEx - News / Tutorials - UiPath Community Forum

And also on doing experiments within the immediate panel
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

So you can explore and tests directly regex statements e.g. crafted with the help of an online editor like: https://regex101.com/

so you can check on the following strategies:

  • matching (strict)
  • match all variations, then replace inner unneeded chars

Pattern was given before

and was addressing the origin:

17

i invoked the below code…it says no match found though match is found

Invoke code:
’ Input String
Dim inputStri As String = “Freight Pickup: 232613 LTL Less-Than-Truckload (Dry Van) from Langley Township, BC to Sumner, WA Associated CSA Quote Number: Q315362 Your Email: orders@panefri.com”

’ Regex Pattern
Dim patte As String = “(?<=^W?Q)#\s/-”

’ Perform Match
Dim matchResult As String = “”
Dim match As System.Text.RegularExpressions.Match = System.Text.RegularExpressions.Regex.Match(inputStri, patte)

’ Check if a match is found
If match.Success Then
’ Combine “WQ” or “Q” with the digits
matchResult = match.Groups(1).Value.ToLower() & match.Groups(2).Value
Else
matchResult = “No match found”
End If

’ Assign the result back to UiPath variable
result = matchResult

The image shows a VB.Net code snippet that uses a regular expression to search for a specific pattern in an input string and assigns the match result to a variable. (Captioned by AI)
The image shows a VB.Net code snippet that uses a regular expression to search for a specific pattern in an input string and assigns the match result to a variable. (Captioned by AI)1193Ă—619 27.4 KB

I need to complete this by today…Please help

18

not needed, can be done without blackboxing

19

when i tried your pattern… it gives the actual input

This image shows the interface of UiPath Studio displaying a sequence for string manipulation, including variable assignments and a Write Line activity, with details of the debug output visible. (Captioned by AI)
This image shows the interface of UiPath Studio displaying a sequence for string manipulation, including variable assignments and a Write Line activity, with details of the debug output visible. (Captioned by AI)1226Ă—804 54.3 KB

20

"(\bW?Q)([\D]?)(\d+\b)\b"

This image shows a programming debugging window where a string pattern and text are defined, a regular expression is used to find a match, and the first match found is "Q315362". (Captioned by AI)
This image shows a programming debugging window where a string pattern and text are defined, a regular expression is used to find a match, and the first match found is "Q315362". (Captioned by AI)704Ă—242 48.7 KB

will work also on the variation:

The image shows a screenshot of a Visual Studio Immediate Window where a regular expression pattern is used to find and extract a specific alphanumeric quote number ("WQ-12345678") from a provided text string. (Captioned by AI)
The image shows a screenshot of a Visual Studio Immediate Window where a regular expression pattern is used to find and extract a specific alphanumeric quote number ("WQ-12345678") from a provided text string. (Captioned by AI)696Ă—193 50.3 KB

And will handle not found Match

The image shows a debugging session with a string extraction in progress; strText contains a freight pickup detail, and the output of a regex match operation is "NotFound". (Captioned by AI)
The image shows a debugging session with a string extraction in progress; strText contains a freight pickup detail, and the output of a regex match operation is "NotFound". (Captioned by AI)715Ă—219 49.3 KB

For sure it can be adapted and modified if it is needed

Also have a look here:
[HowTo] LINQ (VB.Net) Learning Catalogue - Help / Something Else - UiPath Community Forum

1 Like