How to get de first letter as uppercase

CD58

New Member
How do i get the first letter as an uppercase letter from a data item. If i use de calculate Upper then all the letters will be UPPERcase
 

dallangoldblatt

New Member
i need the whole word to be changed with this i only get the letter back.

test has to be Test

I have used the function


Replace([Data1]; Left([Data1]; 1); Upper(Left([Data1]; 1)))

What i get is: TesT

Sorry, I misunderstood what you were asking for.

Try: Upper(Left([Data1], 1)) & Right([Data1], Len([Data1])-1)
 

sudarshanhande

New Member
"i love blue prism" is converted into "I Love Blue Pirsm" with following functions like upper lower and mid-

Upper(Left([Text], 3))&Lower(Mid([Text], 4, 3))&" "&Upper(Mid([Text], 8, 1))&Lower(Mid([Text], 9, 3))&" "&Upper(Mid([Text], 13, 1))&Lower(Mid([Text], 14, 4))
 

Attachments

  • capital.jpeg
    capital.jpeg
    171 KB · Views: 16
Top