On a customer name field, we wish to handle user input in incorrect case. So &q

alastairw over 10 years ago

On a customer name field, we wish to handle user input in incorrect case. So "SMITH" and "smith" should both becode "Smith".

The obvious way to do this is proper(ac!surname). However, proper("Cholmondley-Warner") results in "Cholmondley-warner" since hyphen is not a word delimiter. Any suggestions for a workaround?...

Discussion posts and replies are publicly visible

Parents

0 alastairw over 10 years ago

Thanks Elizabeth, I've taken your rule (with credit)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 alastairw over 10 years ago

Thanks Elizabeth, I've taken your rule (with credit)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data