2 Replies Latest reply: Dec 2, 2014 1:29 PM by John McNamara RSS

    Locate first uppercase character in a string

    John McNamara

      Hi,

       

      I have a field with upper and lowercase characters. I need to identify the first instance of an uppercase character in the string so that I can extract the next three characters. Is this possible? The problem I have is that the position of the first uppercase character in the string keeps on changing so I can't use LEFT/RIGHT functions. I am also unable to use the SUBFIELD function with this particular string as the data before the first uppercase character isn't consistent.

       

      Example: 123abdJJJghk (need to extract JJJ in this string)