0
Pulling capital letters out of a string
My wife has this funny file system where we use the year, a sequential number, and the first letters of two peoples names. Is there any chance I can have a string fill with just the Capital Letters from a string? Cheers..!
1 reply
-
To get the first letter of a text field an capitalise it use this formula:
–––
upper(substr('field name', 0, 1))
–––Birger
Content aside
- 7 yrs agoLast active
- 1Replies
- 1512Views