Using Regex to replace texts in string

[Komom]

I used OCR to extract text from a pdf file but the extracted texts are rather messy:

[REDACTED]
=~ i.
=>» Goldman w 3
BofA SECURITIES “ZZ” Soman Si @)i@imEms HATONG

Is it possible for me to remove those nonword characters and the word “[REDACTED]” to make it tidier using Regex? As I don’t want to have to many activities to replace unwanted words. Thank you very much for your help!

[Supriya_Allada]

Hi @Komom

Try this:
res = System.Text.RegularExpressions.Regex.Replace(extractedText, "[^\w\s]|\[REDACTED\]", "")

[sppal.c]

have a look at this thread.

How to 'System.Text.RegularExpressions.Regex.Replace'

I want to know how to change the following using regular expression. input data : 123456 after replace : 12-34-56

[yedukondaluaregala]

Hi @Komom ,

To extract [READACTED] from given text you can use below pattern
[a-zA-Z]+\n

in UiPath
system.text.regularexpression.regex.match(input,“[a-zA-Z]+\n”).tostring

it will extract [READACTED] from given text.

Please try it and let me know if you are facing any challenges

[Komom]

thank you very much for your help!

[Komom]

Thank you very much for your help!

[Gowtham_K115 (Gowtham Krishnan)]

Hi @Komom

try this

System.Text.RegularExpressions.Regex.Replace("inputstring","\[.*\]","").ToString

Regards,
Gowtham K