ProperCase formula for Crystal 8.5 2

[debby59]

I have a name field (joe bloggs) that i wish to convert to (Joe Bloggs). There is no ProperCase choice in formula area. Can someone please assist with this?

 

[Naith]

You can download the LeadingCaps UFL (U2lcaps.dll) from support.crystaldecisions.com, which acts like ProperCase.

Naith

 

[crystalvictim]

If using an UFL is not a valid option for you and there's only a single field involved, you might consider using a formula such as:

local stringvar array la_name:='';
local numbervar l_i;
local stringvar l_result:='';
la_name:=split({TABLE.FIELDNAME});
for l_i:=1 to ubound(la_name) do
(
l_result:=l_result & ucase(left(la_name[l_i],1)) & right(la_name[l_i],length(la_name[l_i])-1) &
if l_i<ubound(la_name) then &quot; &quot;;

);
l_result;