Picking a string out of a text field and making it upper case.

rjj88 — Tue, 12 May 2015 15:10:23 GMT

Hi all.. My first of what will probably many, many noob-question posts.

Can anyone suggest how to select a specific word and make it upper case?
E.g. A rich text field contains a block of text in which my surname appears twice - can I make those two instances of my surname upper case?

Additionally, if my surname is entered in another 'SURNAME_field', can it be referenced in the function so, perhaps, someone else's name could be used?

I'm sure it's possible with a lengthy function, but I'm not clued up enough to build one!

PS. - I found lots of questions being answered about making all text in a field upper case, or just capitalizing the first letter using the functions below, but not picking out a specific string.

1) Convert all to uppercase:
translate(., "abcdefghijklmnopqrstuvwxyz", "ABCDEFGHIJKLMNOPQRSTUVWXYZ")

2) Convert first letter to uppercase:
concat(substring(translate(., "abcdefghijklmnopqrstuvwxyz", "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), 1, 1), substring(., 2, string-length(.) - 1))

General

Picking a string out of a text field and making it upper case.