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 fabricec over 9 years ago

Ok, so you can split the text with spaces, then for each part, you can test if the part is in uppercase (with the like() function, using regular expression) and if not, use the proper function.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 fabricec over 9 years ago

Ok, so you can split the text with spaces, then for each part, you can test if the part is in uppercase (with the like() function, using regular expression) and if not, use the proper function.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data