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