Convert text to upper case in a calculation?

I would like to use a piece of text entry to create an ID code, I will be using the first three letters of a location entered as text in a calculation.

Is there a way to convert this text to upper case so those three letters are all capital letters?

I would prefer not to go down the route of forcing entry in upper case using regex.

You can use the translate() function in a calculation, see Form Operators and Functions - ODK Docs.
As often, the search function of this forum can provide more hints and examples, please, e.g. Enter Text to be in Uppercase - #4 by Kal_Lam.

2 Likes

@wroos, :clap: :heart: :partying_face: