Just curious... What are trying to search for?Hi, is there a way to search for ALL CAPITAL LETTERS (UPPERCASE)? I am pretty sure it could be done via the character string search or RegEx search, but I do not know how.
Can someone help me out?
Thank you!
Hi, is there a way to search for ALL CAPITAL LETTERS (UPPERCASE)? I am pretty sure it could be done via the character string search or RegEx search, but I do not know how.
Can someone help me out?
Thank you!
| String | Match Count |
| LORD | 6166 |
| GOD | 305 |
| O LORD | 295 |
| LORD'S | 108 |
| JESUS | 4 |
| LORD I | 3 |
| MENE | 3 |
| O GOD | 3 |
| BRANCH | 2 |
| HOLINESS TO THE LORD | 2 |
| JEHOVAH | 2 |
| LORD JEHOVAH | 2 |
| TEKEL | 2 |
| AIN | 1 |
| ALEPH | 1 |
| AND LORD OF LORDS | 1 |
| BABYLON THE GREAT | 1 |
| BETH | 1 |
| CAPH | 1 |
| CHETH | 1 |
| DALETH | 1 |
| GIMEL | 1 |
| HE | 1 |
| HOLINESS UNTO THE LORD | 1 |
| I AM | 1 |
| I AM THAT I AM | 1 |
| JAH | 1 |
| JESUS OF NAZARETH THE KING OF THE JEWS | 1 |
| JOD | 1 |
| KING OF KINGS | 1 |
| KOPH | 1 |
| LAMED | 1 |
| MEM | 1 |
| MYSTERY | 1 |
| NUN | 1 |
| PE | 1 |
| PERES | 1 |
| RESH | 1 |
| SAMECH | 1 |
| SCHIN | 1 |
| TAU | 1 |
| TETH | 1 |
| THE KING OF THE JEWS | 1 |
| THE LORD OUR RIGHTEOUSNESS | 1 |
| THE LORD THY GOD | 1 |
| THE MOTHER OF HARLOTS AND ABOMINATIONS OF THE EARTH | 1 |
| THIS IS JESUS THE KING OF THE JEWS | 1 |
| THIS IS THE KING OF THE JEWS | 1 |
| TO THE UNKNOWN GOD | 1 |
| TZADDI | 1 |
| UPHARSIN | 1 |
| VAU | 1 |
| ZAIN | 1 |
Brandon, thank you very much! This search gives exactly what I was looking for.I think this is a better one:
(?! )\b[A-Z ']{2,}\b(?<! )
- Assert that it is impossible to match the regex below starting at this position (negative lookahead)
- Match the character “ ” literally
- Assert position at a word boundary (position preceded or followed—but not both—by a letter, digit, or underscore in the active code page)
- Match a single character present in the list below
- Between 2 and unlimited times, as many times as possible, giving back as needed (greedy)
- A character in the range between “A” and “Z” (case sensitive)
- A single character from the list “ '”
- Assert position at a word boundary (position preceded or followed—but not both—by a letter, digit, or underscore in the active code page)
- Assert that it is impossible to match the regex below ending at this position (negative lookbehind)
- Match the character “ ” literally
View attachment 2584
View attachment 2585
Matching Strings:
String Match Count LORD 6166 GOD 305 O LORD 295 LORD'S 108 JESUS 4 LORD I 3 MENE 3 O GOD 3 BRANCH 2 HOLINESS TO THE LORD 2 JEHOVAH 2 LORD JEHOVAH 2 TEKEL 2 AIN 1 ALEPH 1 AND LORD OF LORDS 1 BABYLON THE GREAT 1 BETH 1 CAPH 1 CHETH 1 DALETH 1 GIMEL 1 HE 1 HOLINESS UNTO THE LORD 1 I AM 1 I AM THAT I AM 1 JAH 1 JESUS OF NAZARETH THE KING OF THE JEWS 1 JOD 1 KING OF KINGS 1 KOPH 1 LAMED 1 MEM 1 MYSTERY 1 NUN 1 PE 1 PERES 1 RESH 1 SAMECH 1 SCHIN 1 TAU 1 TETH 1 THE KING OF THE JEWS 1 THE LORD OUR RIGHTEOUSNESS 1 THE LORD THY GOD 1 THE MOTHER OF HARLOTS AND ABOMINATIONS OF THE EARTH 1 THIS IS JESUS THE KING OF THE JEWS 1 THIS IS THE KING OF THE JEWS 1 TO THE UNKNOWN GOD 1 TZADDI 1 UPHARSIN 1 VAU 1 ZAIN 1