How to identify big letters in a text string

#1

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!

0 Likes

#2

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?

0 Likes