Private Sub Tools_Text_Format_TeamCenter_Document_Numbers()
'
' find teamcenter document numbers and format them
'
' https://regex101.com/
'
    Dim arrFindReplaceExpressions()
    Dim varCounter As Variant

    arrFindReplaceExpressions = Array("<([0-9A-Z]{4}[.])([0-9A-Z]{7}[.])([0-9A-Z]{3}[.])([0-9A-Z.]{4})>", _
                                      "<([0-9A-Z]{4}[.])([0-9A-Z]{7}[.])([0-9A-Z]{3}[.])([0-9A-Z.]{2})>", _
                                      "<([0-9]{8}[.])([0-9A-Z]{3}[.])([A-Z]{2})>")
    
    For Each varCounter In arrFindReplaceExpressions
        Selection.Find.ClearFormatting
        Selection.Find.Replacement.ClearFormatting
        With Selection.Find
            '.Replacement.Text = ""
            .Text = varCounter
            .Replacement.Font.Bold = True
            .Forward = True
            .Wrap = wdFindContinue
            .Format = True
            .MatchCase = False
            .MatchWholeWord = False
            .MatchAllWordForms = False
            .MatchSoundsLike = False
            .MatchWildcards = True ' needed for special characters, otherwise they're treated as ordinary text
            .Execute Replace:=wdReplaceAll
        End With
    Next varCounter
    
    Set varCounter = Nothing
    Erase arrFindReplaceExpressions
    
    Debug.Print "Finished!"
End Sub