Ruby has a few methods for changing the case of strings. To convert to lowercase, use downcase: Similarly, upcase capitalizes every letter and capitalize capitalizes the first letter of the string but lowercases the rest: If you want to modify a string in place, you can add an exclamation point to any of those methods: … Read more
Here’s a UDF that will do the trick… You will still have to use it to update your data though.
To some extent, this is going to vary by the “flavour” of RegEx you’re using. The following is based on .NET RegEx, which uses \b for word boundaries. In the last example, it also uses negative lookaround (?<!) and (?!) as well as non-capturing parentheses (?:) Basically, though, if the terms always contain at least one uppercase letter followed by at least … Read more
You need to put a double colon before toupper: Explanation: There are two different toupper functions: toupper in the global namespace (accessed with ::toupper), which comes from C. toupper in the std namespace (accessed with std::toupper) which has multiple overloads and thus cannot be simply referenced with a name only. You have to explicitly cast it to a specific function signature in order to … Read more
You have to use the String method .toLowerCase() or .toUpperCase() on both the input and the string you are trying to match it with. Example:
Use .lower() – For example: The official 2.x documentation is here: str.lower()The official 3.x documentation is here: str.lower()