Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners Click HERE | EMEA/APJ Click HERE |
04/18/2023 11:14 AM
Is there an easier way to convert strings into Title Case format? Currently I have the following logic in CreateAccountJSON API call to ServiceNow which works as expected:
User's middle names are all in uppercase in our user schema.
There is a case where users have multiple middle names. That is why you me using split logic to handle the scenario where a user has 2 middle names. In my if-logic I use .contains(' ') because these other methods did not work as if-conditions:
04/18/2023 01:13 PM
You can create dyanmic attributes and manage this using sql query and use dynamic attribute variables in json
04/18/2023 01:44 PM
Do you happen to have an example or documentation I could use to change our middle name values to title case using sql query? I already know how to use dynamic attributes within the JSON.
04/18/2023 08:06 PM
Select CONCAT(UPPER(SUBSTRING(firstname,1,1)),LOWER(SUBSTRING(firstname,2))) AS Name FROM USERS
04/19/2023 06:41 AM
Would this handle the scenario in which users have multiple middle names?
Select CONCAT(UPPER(SUBSTRING(middlename,1,1)),LOWER(SUBSTRING(middlename,2))) AS Name FROM USERS
For example, a user with middle names BYAN SMITH. Would this logic convert these names into Byan Smith? How about user's with a hyphenated middle name? For example, BYAN-SMITH?