145
Hello Everyone,
Kindly help me I want below result in name field , How would I get.
I want first and last string compulsary and then first letter from second string, Some Example I have given as show below.
|
Name in the system |
Result |
|
Andrew CUSHION |
Andrew CUSHION |
|
Andrew Dean CUSHION |
Andrew D CUSHION |
|
Andrew Dean Gerald CUSHION |
Andrew D CUSHION |
|
Andrew Dean Gerald Arnold CUSHION |
Andrew D CUSHION |
If you look at the standard system and how names are handled, there are separate fields for first, middle and last names. Please follow this same approach in your functionality.
Then it's also very easy to achieve the result that you need:
1) Take the value from FirstName field
2) Take first character from MiddleName field
3) Take the value from LastName field.
Your problem is caused by a wrong data model. You're violating the first normal form by not having atomic values in the name. Consider fixing the model, rather than building workarounds in code.
If you can't fix the model, take the string and split it to words, e.g. by strSplit(name, ' '). Then take the first and last ones and if the number of words is higher than 2, take the second word and extract the first character by subStr().
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (