Convert JOE SMITH to Joe Smith. How to do it in CR8.5? 1

[Digitalcandy]

Fairly simple question that I havn't found an answer.

Anyone?

 

[Naith]

The answer you're waiting for is to download the U2lcaps.dll from

http://support.crystaldecisions.com.

Naith

 

[Digitalcandy]

I'm guessing that will work with a CR environment but we use our reports in a 3rd part software and I'm affraid it will not run in that environment.

I was hoping to use a function that's packaged with CR 8.5

 

[Madawc]

I think you'll need to do it the slow way, converting one character at a time.

Madawc Williams
East Anglia, Great Britain

 

[Naith]

That function exists on the website because there is no prepackaged ProperCase function in Crystal prior to v9.

If you cannot use that, use a formula. You don't have to be as meticulous as converting one letter at a time; simply lcase the entire string and switch the first letter of each word for the ucase variant.

Read thread767-568676

Naith

 

[synapsevampire]

In CR 8.5 and earlier, to format the string or text field similar to the ProperCase function, use the LeadingCaps User Function Library (UFL). The LeadingCaps UFL can be obtained by searching for the file name, Uflcaps.exe, on our support site at:

http://support.crystaldecisions.com/

This file contains the U2lcaps.dll (for 32-bit applications) and the Uflcaps.dll (for 16-bit applications). Refer to the Readme.txt file for the correct installation of the Dynamic Link Library (DLL).

The LeadingCaps function capitalizes the first character of a string after a space, tab or hyphen.

-k

 

[Digitalcandy]

Thanks for the suggestions everyone.

I'll test them out.