Regex in Pattern.compile to split BillingStreet into custom street and house number field

Question

I want to split BillingStreet into a custom Street__c and HouseNumber__c. According to what I have read so far online, I need to:

1. Instantiate a new Pattern object

   //Pattern 'Test Street 123' OR '123 Test Street' OR 'Test 123 Street'
   
   Pattern MyPattern = Pattern.compile('[^\\d]*([\\d]+)[^\\d]*');
   

2. Instantiate a new Matcher object

   Matcher MyMatcher = MyPattern.matcher(account.BillingStreet);
   

3. Process the result

   if(MyMatcher.matches()){
   
      account.Street__c = MyMatcher.group(???);
   
      account.HouseNumber__c = MyMatcher.group(1);
   
    }
   

The code for the House Number is working. But I need it to work for Street and also to enhance the Regex with the following examples: 'Further Test Street 123', '123 Further Test Street', 'Test Street 123a', '123a Test Street', 'Test 123a Street', 'Further Test Street 123a', '123a Further Test Street', 'Street 123', '123 Street', 'Street 123a', '123a Street' and all the same with 'Further-Test-Street 123' ...

Answer 1

My favorite site to help with RegEx things like this is GSkinner's RegEx site where you can test these patterns and it also has a lot of help.

What you're going to want to do with this is is create a group to capture the digits as optional followed by another optional group to catch the alpha character, again as optional, then a group to capture the street name (not optional), followed by a group to capture "Street" OR "St" (OR "AVE" OR "BLVD" OR "Boulevard" OR "Avenue"} all as optional for the OR group followed by and optional ".". Since you're showing all these in various orders with a "-" between them, it's unclear to me where that's coming from or if you want to format them in that manner. You might want to go through these in some kind of sequence to pull each of these out separately and then reassemble them.

You'll be able to test these different scenarios at the site I've referred you to which walks you through the scenarios. It has YouTube videos to show you how to do things with walk through examples. Rather than solve this for you, I'm giving you the strategy to work this out for yourself.