Converting UpperCase to title case

[EMVIC]

Can anyone help. I have column called Title and contains titles in Uppercase eg TIT/MR, TIT/MS, TIT/PROF. i used
mid('TIT/MR',5,99) to get rid of TIT/, my problem is how to convert the MR or MS to Mr or Prof, combined with the formula

 

[synapsevampire]

Please post your software version with any post about any software product.

Try using:

Propercase({table.field})

Not sure why you'd hardode a string and then use mid against it to eliminate it, I assume that you're just too busy to use the actual field name...

I would take a different approach to that as well, and given your limited understanding of Crystal, you should not state architecture, rather post technical information and ask for assistance.

I'd use:

if instr({table.field},"/") > 0 then
mid((propercase({table.field}),instr({table.field},"/")+1)
else
(propercase({table.field})

Successful posts tend to include basic info:

Crystal version
Database/connectivity used
Example data
Expected output

-k

 

[EMVIC]

Appologies for not supplying the detailed info. CR version: 8.5, DB : SQL 2000. It seems CR8.5 doesnot recognise Propercase. Is there any other way around it.

 

[synapsevampire]

Right, CR 8.5 doesn't support it, please post basic technical info in future posts so as not to waste everyone's time.

You need the LeadingCaps UFL:

http://technicalsupport.businessobj...sliceId=&dialogID=5168250&stateId=1 0 5166572

-k