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

null
    • Birger_H
    • 5 yrs ago
    • Reported - view

    To get the first letter of a text field an capitalise it use this formula:

    –––
    upper(substr('field name', 0, 1))
    –––

    Birger

Content aside

  • 5 yrs agoLast active
  • 1Replies
  • 1511Views