DanLadner1
6 years agoQrew Trainee
Re: Text To Proper Case
This is a bit gnarly, but works...
var text fieldOne = [input]; var text fieldOneWordOne = Part($fieldOne,1," "); var text fieldOneWordTwo = Part($fieldOne,2," "); var text fieldOneWordThree = Part($fieldOne,3," "); var text fieldOneWordFour = Part($fieldOne,4," "); var text fieldOneWordFive = Part($fieldOne,5," "); var text output = List(" ", Upper(Left($fieldOneWordOne,1)) & Lower(NotLeft($fieldOneWordOne,1)), Upper(Left($fieldOneWordTwo,1)) & Lower(NotLeft($fieldOneWordTwo,1)), Upper(Left($fieldOneWordThree,1)) & Lower(NotLeft($fieldOneWordThree,1)), Upper(Left($fieldOneWordFour,1)) & Lower(NotLeft($fieldOneWordFour,1)), Upper(Left($fieldOneWordFive,1)) & Lower(NotLeft($fieldOneWordFive,1))); $outputThis will account for up to 5 words, you can adjust accordingly.