Forum Discussion

PamelaKopterska's avatar
PamelaKopterska
Qrew Member
5 years ago

Capital Letters

Hi All, I need to extract Capital Letter from the string. My field is called Fullname and the format is like NameLastname. My task is to separate it by adding "." after Name. Is there some kind of ...
Formulas and functions
SamJones1's avatar
SamJones1
Qrew Cadet
Hey Pamela,

Thanks for the fun challenge! Great way to get my brain warmed up for a day of App building. 

var text one = NotLeft([Name Text], 1);
var number firstNameLength = Length(Left($one, "ASDFGHJKLZXCVBNMQWERTYUIOP"))+1;
var number lastnamelength = Length([Name Text])-$firstnamelength;
Left([Name Text], $firstnamelength)
 & "." &
Right([Name Text], $lastnamelength)​
What this will do is insert a period before the first capital letter that is not the first character in the text string.

"RonaldMcDonald" becomes "Ronald.McDonald", but "HRGieger" will become "H.RGeiger".

Hope it helps, and if you need any more assistance, the team at Data Collaborative handles this kind of thing and more all the time!


------------------------------
- Sam

______________________________________________
Sam Jones
Vice President, Product and Technology
he/him

The Data Collaborative, Inc.
sjones@datacollaborative.com
366 Massachusetts Ave, Suite 203 | Arlington, MA 02474
------------------------------
AustinK's avatar
AustinK
Qrew Commander
5 years ago
Nice I was looking at the formula references and I was thinking of something much larger. I have never run into this issue because I always split my names and do not do full names so I have never even had to consider this. Glad to see it actually can be done in a native way that wasn't as large as I thought it might be.