Regex_Replace Syntex Parse Error

[sslattery17]

I have a column Bldg-Units that has a lot of data, both unit and property name; I am trying to replace the property names with blank or empty cells leaving remaining data that I will fill down at a later time.  I am getting parse error, can someone help me figure out what I am doing wrong?  Thanks in advance. 

regex_replace([Bldg-Unit ], "11th & Spruce",
"250 High",
"600 Goodale",
"80 On The Commons",
"801 Polaris",
"Baxter Park",
"Bracken House",
"Buckstone Flats","Burrough"s Mill",
"Devonshire",
"Dixon House",
"Edison at Gordon Square",
"Emerson Park",
"Gateway Lakes",
"Gateway Lofts Centerville",
"Gateway Lofts Columbus",
"Gateway Lofts Lansing",
"Gateway Lofts Lexington",
"Graham Park at The Highlands",
"Harper House at The Highlands",
"Heritage Green",
"Lane Lofts",
"Lofts at Norton Crossing",
"Lumina",
"Luxe 88",
"Luxe at The Highlands",
"Madison House",
"Marina Lofts",
"Marine Club",
"Market & Main",
"Minnetonka Station",
"Mulberry Lofts",
"North Shore Flats",
"Packard Building",
"Park"s Edge at Shelby Farms",
"Pennbrook Station",
"Polo Run Apartment Homes",
"Pulliam Square",
"Rize at Opus Park",
"Spectra",
"Spring House at Brandywine",
"Station 324",
"Steel House",
"Stillwell at Avery Centre",
"Stillwell Jerome",
"Stilwell at Wellen Park",
"Sugar Run",
"The Aubrey",
"The Baylor",
"The Darby at Briarcliff",
"The Flats at Douglas",
"The Gramercy",
"The Jacqueline",
"The Kingston",
"The Monarch",
"The Normandy",
"Preserve at Forest Creek",
"The Reserve of Sugarcreek",
"The Stratton",
"The Thomas",
"View on Grant",
"Tribeca",
"Willis Avondale Estates", "")

[binuacs]

@sslattery17 lets apply the above regex  on your data and see whether you are getting the correct result. instead of the above regex you can also use the regex IIF(REGEX_Match([Bldg-Unit], "\b\w+\b"), [Bldg-Unit], "")

[sslattery17]

@binuacs 

I used IIF(REGEX_Match([Bldg-Unit ], "\b\w+\b"), [Bldg-Unit ], "")

It's actually removing the hyphen between the unit numbers but it does remove all the property names.  I need the - between the unit numbers if they exist.

[atcodedog05 · Accepted solution]

Hi @sslattery17 

Try

IIF(REGEX_Match([Bldg-Unit], "\d+-?\d*"), [Bldg-Unit], "")

This should handle n number of numbers

Hope this helps : )

[sslattery17]

@atcodedog05 Thank you so much; I tried a few different Syntex but could not get the result. 

I much apprecate your help and @binuacs too on this.  I am still learning so the community help is my life saver.