Hello, I want to create a rule that takes in a text string and capita

issamd over 9 years ago

Hello,

I want to create a rule that takes in a text string and capitalizes in appropriately, but the proper() function won't work.

For example, if the string passed in is "MMB bank", the proper() function will return "Mmb Bank", when I need "MMB Bank".

Does anybody have a suggestion that I can use?

Discussion posts and replies are publicly visible

Parents

0 gpolk over 9 years ago

I think you might still run into trouble if your user entered THE BANK OF MMB AND XYZ. You may have difficulty telling the difference between MMB & XYZ strings which should be all caps and the AND string which should be proper case.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 gpolk over 9 years ago

I think you might still run into trouble if your user entered THE BANK OF MMB AND XYZ. You may have difficulty telling the difference between MMB & XYZ strings which should be all caps and the AND string which should be proper case.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data