cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerPlatformK
New Member

Remove Spaces in String Text

Hi currently I have a field from data verse which stores the account name,  I need spaces to be removed from the account name so i can use it for a URL I'm trying to construct.

 

For example ;

Account name = "Test ABC 123" 

I would need the output to be "TestABC123"

 

Can any one help?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Pstork1
Dual Super User III
Dual Super User III

Have you tried using a Replace which targets a space and replaces it with an empty string?

replace('Test ABC 123',' ', '')


-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

2 REPLIES 2
Pstork1
Dual Super User III
Dual Super User III

Have you tried using a Replace which targets a space and replaces it with an empty string?

replace('Test ABC 123',' ', '')


-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

my problem is similar!!!

For example;
input (text): 1 406 502
I want output: 1406502

 

My question: In the case of the 'power automate desktop' program, what functions and values do I need to use to get the output result?

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,595)