Regexp to match Captial cases in address Pattern

Question

I want a regular expression to find addresses having mixed characters that can be used in Alteryx. The first example has capital cases in the beginning and second one in between.

IFBDAGE,Place des Augustins 19,Bonita Springs
28/10 Macquarie Street,NEWSTEAD,Bonita Springs

I could get first capital cases using \b[A-Z0-9]{2,}\b, but not sure how to find in between the string — MKrishnaPillai, Aug 04 '16 at 10:49

score 0 · Answer 1 · answered Aug 04 '16 at 11:49

0

Don't do it with regular expressions. Make your life easier and use a normal function:

public static string GetUpperCasePart(string address, char delimiter)
{
    foreach (var part in address.Split(delimiter))
    {
        if (part.All(c => Char.IsLetter(c) && Char.IsUpper(c)))
            return part;
    }

    return string.Empty;
}

Working example: https://dotnetfiddle.net/x3NxOJ

answered Aug 04 '16 at 11:49

Good Night Nerd Pride

8,245
4
49
65

Can we do run this as stored procedure in SQL? I have the addresses in one column.. – MKrishnaPillai Aug 08 '16 at 05:31

score 0 · Answer 2 · answered Aug 04 '16 at 12:33

0

In your regex \b[A-Z0-9]{2,}\b why are you using 0-9, if you just use \b[A-Z]{2,}\b, it will give the capital letters in the middle as well.

answered Aug 04 '16 at 12:33

Anita

1
3

This works....But it will also return the addresses with full caps...I want only the ones with Mixed cases. – MKrishnaPillai Aug 08 '16 at 04:56

score 0 · Answer 3 · answered Aug 04 '16 at 12:36

0

assuming that your Strings don´t contain the capitals in upperCase, matching should be difficult... Otherwise, Abbondanza´s solution is working and you can use the RegEx like Anita explained ;)

answered Aug 04 '16 at 12:36

BingBingBong

88
10

Regexp to match Captial cases in address Pattern

3 Answers3