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

"(\bW?Q)([\D]?)(\d+\b)\b" <a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/6/d/c/6dcbc5cea60f9b3acd8b8169244177f17dfc054e.png" data-download-href="/uploads/short-url/fFiCLqEx9Ngw8PIJhA5L2b27bYi.png?dl=1" title="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)] will work also on the variation: <a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/9/4/f/94fd2d42080a61812093c5ba2179aa9000b77b78.png" data-download-href="/uploads/short-url/lg15QQVIbCWnoXzjfTG4wcdZW8U.png?dl=1" title="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 Vi…

[image] sharu_priya: The actual output should be like wq1234567 and q1234567 Wq followed by 7digit and q followed by 7 digit. Regex.Replace(input, “(?i)(WQ|Q)[#\s/-]*(\d{7})”, Function(m) m.Groups(1).Value.ToLower() & m.Groups(2).Value)

Hey @sharu_priya try this code <a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/9/6/e/96eac7c0c3eb1b0b5a89a6e1a95b5c0ca5af6967.png" data-download-href="/uploads/short-url/lx4DmYgAl1ACJTErXcaAHiQcFqn.png?dl=1" title="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)] <a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/3/a/a/3aa22a418c11afbaffce04423d3fa4266fb2693e.png" data-download-href="/uploads/short-url/8mH84Zozc9vKiZO2m5voDeS1qLs.png?dl=1" title="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 Expres…

Hey @sharu_priya Try this approach: BlankProcess13.zip (3.0 KB) <a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/3/7/7/3775dd0c21b9cf47af9509cead677eef419b89d5.png" data-download-href="/uploads/short-url/7UCMuJ0ximssaSadIznNKiRdhsx.png?dl=1" title="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)" rel="noopener nofollow ugc">[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 remov…

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

[image] sharu_priya: WQ#1234567 WQ 1234567 WQ/1234567 WQ-12345678 Q#1234567 Q 1234567 Q/1234567 Q-12345678 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)] n Use …

will try and let you know… Thanks much

@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 …

[image] Regex pattern to remove special character Studio 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)] n Use above sequence. Don’t forget to Impo…

@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

Hey @sharu_priya Please check this solution: BlankProcess13 (2).zip (2.6 KB) <a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/f/1/c/f1c85d6e85ffc3cb7ac6450a16fc9b827bc19c31.png" data-download-href="/uploads/short-url/yuUlIIeO8m3oWrv98NAouhBjziN.png?dl=1" title="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)" rel="noopener nofollow ugc">[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)]

Regex pattern to remove special character

Help Studio

adi.mehare (Aditya Mehare) January 9, 2025, 1:07pm 6

Main.xaml (7.7 KB)

n
Use above sequence.
Don’t forget to Import System.Text.RegularExpression namespace

Topic		Replies	Views
How to seperate special characters in string Activities uiautomation , activities	6	869	February 20, 2023
Remove special characters at the string Activities web	10	793	October 18, 2023
How do i remove special characters from a string? Help studio	11	44750	January 27, 2020
How to remove a special characters in a given string by regex Studio regex , text	8	3375	September 27, 2023
Removing special character from the below Strings Studio studio , question , activities_panel	24	743	December 19, 2023

Regex pattern to remove special character

Related topics