Count the number of upper case letters in a string

qzqzqzqzqz · 2024-10-29T15:06:07+00:00

There was an error rendering this rich post.

I am trying to determine if all letters in a field are capitalized. for example:

String| Count

ABC | 3

abc | 0

Abcd |1

How can I calculate the 'Count' in this example?

Find more posts tagged with

LENGTH(Uppercase) - LENGTH(REGEXP_REPLACE(Uppercase, '[A-Z]', ''))

LENGTH(Uppercase) - LENGTH(REGEXP_REPLACE(Uppercase, '[A-Z]', ''))

I think you have to do this in an ETL, because REGEXP_REPLACE() doesn't work for me inside of a card.

LENGTH(REGEXP_REPLACE(`sample`,'[^A-Z]',''))

thanks all!! this was resolved; I used the formula in Data Flow.