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"
@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.
I am using this Replace Text and it is replacing the spaces with []. What am I doing wrong?
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.
can you tell me how can I do this in Power Automate Desktop
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.
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.
WarrenBelz
146,731
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,075
Most Valuable Professional