Remove all spaces from string

(1) Share

Report

Posted on by cbernier12

248

Hi, does anyone know how to remove all spaces from a string, thus concatenating it?

Example: "this is my string" when all spaces are removed it looks like "thisismystring"

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Gopala_Krishna 1,495 on at

Like (7)

Report

@cbernier12

In the below example I have put the sentence inside a variable and used the expression to remove the whitespace.
You can also directly put the string and use the expression.

replace(variables('test'),' ','')

Replace accepts three arguments, the string, pattern to search for (to be specified in single quotes), pattern to be replaced with(to be specified in single quotes).

If the information shared helps you, please consider giving a thumbs up 👍 and mark solution as resolved.

Was this reply helpful? Yes No
cbernier12 248 on at

Like (0)

Report

Thanks, I was trying that, however it wouldn't save. I've discovered PA is kind of finicky and you have to select OK a number of times before formulas will take.

Was this reply helpful? Yes No
HarshChauhan 52 on at

Like (1)

Report

can you tell me how can I do this in Power Automate Desktop

Was this reply helpful? Yes No
arjunrajmails 14 on at

Like (2)

Report

In Replace text action,

Enable the option "Use regular expressions for find and replace" and then in text to find use \s

This will remove all the space in your text and replace with the required character. Use \b to replace with null.

Was this reply helpful? Yes No
oprandij 14 on at

Like (0)

Report

I am using this Replace Text and it is replacing the spaces with []. What am I doing wrong?

Was this reply helpful? Yes No
EERC 7 on at

Like (0)

Report

@oprandij wrote:
...What am I doing wrong?
Don't try to format a date as text. If you want to remove spaces in a date, use formatting expression.

The example below shows how I format a date/time to remove spaces. In the next step I compose a string using this formatted date/time with a person's name. This allows me to create a unique ID used in a later step when I assign it as a title to an entity in a document library.

Start by initializing a string variable of your invoice date, with your invoice date property as the value. Then set the variable and format the date.

Was this reply helpful? Yes No