Skip to main content
D
dennisy42803903
Inspiring
December 9, 2022
Answered

GREP for 1st, 2nd, 3rd, 4th

  • December 9, 2022
  • 1 reply
  • 469 views

Hello all,

I'm not so hot with GREP, but I love using it for formating text when I can.

I'd like to apply small caps to "st, nd, rd and th" when used in 1st, 2nd, 3rd, 4th, etc., but I'm having trouble limiting where it is applied. I've tried some positive look behind and look ahead rules, but I'm still failing.

 

I'm using the GREP below:

(?<=\d)th|nd|rd|st(?=.+?)

 

Using it for addressing like below:

151 West 34th Street 

27th Fl.

Long Island City, NY 11101

 

I don't want the "st" in West or the "nd" in Island small affected, but haven't figured out how to control that. Any suggestions greatly appreciated.

 

Thanks,

Dennis

This topic has been closed for replies.
Correct answer m1b

Hi @dennisy42803903, I'm no expert but I'm a huge fan of grep, too 🙂

You could try this:

 

(?<=\d)(th|nd|rd|st)\b

 

 I put parenthesis around the OR choices and added \b (word boundary).

- Mark

1 reply

m1b
Community Expert
m1bCommunity ExpertCorrect answer
Community Expert
December 9, 2022

Hi @dennisy42803903, I'm no expert but I'm a huge fan of grep, too 🙂

You could try this:

 

(?<=\d)(th|nd|rd|st)\b

 

 I put parenthesis around the OR choices and added \b (word boundary).

- Mark

    D
    dennisy42803903Author
    Inspiring
    December 9, 2022

    Hey Mark,

    Thanks for the quick and effective reply. It definitely seems to work. I have to apply this to several hundred addresses, so hopefully I won't find any exceptions. However, first 30 examples look promising. 

    I really appreciate the help. I never thought to use a word boundary like that. I'll add that to my arsenal for next time.

    Thank you!

    -Dennis

    m1b
    Community Expert
    m1bCommunity Expert
    Community Expert
    December 9, 2022

    Yeah the word boundary was to add a little more robustness against matching, say, a wacky start-up company name "12think". Adding the parenthesis to group options separated by bar (|) is almost always essential. In your original grep, I think the lookahead at the end would only apply to "st".

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices