Help

How to identify big letters in a text string

816 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Marie_Witzel
4 - Data Explorer
4 - Data Explorer

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!

1 Reply 1
Mike_McLaughlin
8 - Airtable Astronomer
8 - Airtable Astronomer

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?