Mar 26, 2019 07:07 AM
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!
Mar 26, 2019 10:32 AM
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?