topic Re: Using Regex in Blue Prism to replace newline, tabs and multiple spaces with 1 space in Product Forum

Using Regex in Blue Prism to replace newline, tabs and multiple spaces with 1 space

Tak.Kwok — Tue, 20 Aug 2024 12:18:43 GMT

I am new to using Regex and needed to replace tabs, newline and multiple spaces with 1 space. Appreciate if you can provide the express and how to do that in Blue Prism.

Thanks,

Tak

Re: Using Regex in Blue Prism to replace newline, tabs and multiple spaces with 1 space

Mohamad_Dakkouri — Tue, 20 Aug 2024 15:17:48 GMT

Hi @Tak.Kwok

Please download this vbo Blue Prism Digital Exchange

I will try with this data item

As you can see we have some spaces, tab, and newline

1. Use action Get Regex Matches from VBO Regular Info Extractor and provide this inputs :

For the regex string use this one "[\t\n\r ]+"

Now generate this outputs

2. Use now action Replace RegEx Matches from VBO regular info extractor and provide this inputs :

PS : please note that the [Matched Collection] is the output of the first action

For output generate this :

Now run. Your flow should look like this :

Tell me if its ok 🙂

Re: Using Regex in Blue Prism to replace newline, tabs and multiple spaces with 1 space

MichealCharron — Tue, 20 Aug 2024 19:28:12 GMT

@Tak.Kwok

You can use the one action Regex Replace in BP's Utility - Strings VBO.

With this Data Item:

(Multiple tabs between rain and in. Multiple spaces between spain and falls. Multiple new lines between falls and mainly.)

Using the following text for the Pattern parameter:

\t+|\s{2,}|\n

And a space for the Replacement Data parameter:

Will give you a output parameter data item of:

Re: Using Regex in Blue Prism to replace newline, tabs and multiple spaces with 1 space

Michael_S — Wed, 21 Aug 2024 08:05:54 GMT

Just to drop in and say - excellent answers @MichealCharron and @Mohamad_Dakkouri! Thank you for including screenshots and strings, that's incredibly helpful of you. I'm marking both as Helpful Answers.

@Tak.Kwok - please let us know if you now have the help you need!

Re: Using Regex in Blue Prism to replace newline, tabs and multiple spaces with 1 space

Tak.Kwok — Wed, 21 Aug 2024 11:33:47 GMT

Thanks. This solution works