web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Adding Spaces Between ...

Power Apps

Answered

Adding Spaces Between Capitalized Words

(0) Share

Report

Report

Posted on by BarryCoombs

4

Hi All,

I am building a PowerApp at the moment and need to split a value in two based on the location of the capital letters.

The value is a first and last name. Unfortunately, I have no way of splitting this at source as it is stored as a single value.

Ultimately, I want to turn.

BillSmith into Bill Smith.

Any help would be greatly appreciated.

Cheers

Barry

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @BarryCoombs ,

Please try:

Trim(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute("BillSmith","A"," A"),"B"," B"),"C"," C"),"D"," D"),"E"," E"),"F"," F"),"G"," G"),"H"," H"),"I"," I"),"J"," J"),"K"," K"),"L"," L"),"M"," M"),"N"," N"),"O"," O"),"P"," P"),"Q"," Q"),"R"," R"),"S"," S"),"T"," T"),"U"," U"),"V"," V"),"W"," W"),"X"," X"),"Y"," Y"),"Z"," Z"))

It is also possible to solve this problem ‘cleverly’ by creating loops using Matchall & a timer control, but this method is logically more complicated and I don't think it is necessary.

Best Regards,

Bof

Was this reply helpful? Yes No
BarryCoombs 4 on at

Like
a
(0)

Report
Copy link

Link copied!

That worked, many thanks

Was this reply helpful? Yes No

Join the conversation