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
------------------------------