How to identify big letters in a text string


Need help identifying big letters in text strings, as for example

“McDonald Park Dark-Sky Park, Fraser Valley, BC - 2003”

In that case, I would like to show the “BC” in an extra field. Does anybody have an idea?

Thanks in advance!



can you elaborate as to the intent? (if we just pulled out all the ‘Big’ letters, we would end up with MDPDSPFVBC)

i.e. are you trying to extract the first 2 letters that come after the 2nd or last comma?
or more plainly, trying to extract the province?