Help. My input is Field1. I want to match words in ALL CAPS. There can be 1-N words. I want to ignore lines that might start with an ALL CAPS word or words but that contain other text.
I tried the following expression. It works, but there is an anomaly. It captures { -- when it should not. How can I fix this?
if REGEX_Match([Field1], Uppercase([Field1]),0) then [Field1] else '' endif
Example below. Note { ends up in New when it should not.
| Field1 | New |
| var addthis_config = { | |
| data_use_flash: false, | |
| } | } |
| BIKESExcepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.ices in support o... | |
| SPECIALIZED | SPECIALIZED |
| ROUBAIX PRO | ROUBAIX PRO |
| SWIM BIKE RUN | SWIM BIKE RUN |
| | |