地址数据库清洗：移除门牌号字符串中的多余前导零

Hey there! Great question about cleaning your address database. Let's break this down clearly:

Are there ready-made functions for this? #

Unfortunately, there's no universal off-the-shelf function that perfectly matches this specific rule—address formatting is wildly varied across regions and use cases, so most general-purpose libraries don't cater to every niche edge case like this. That means you'll need to roll your own custom solution, but it's actually pretty straightforward!

Custom Implementation Options #

Here are two solid approaches you can use (I'll use Python for examples, but the logic translates easily to other languages):

1. Split-and-Clean Approach (Simple & Readable)

This method splits the string by slashes, cleans each segment individually, then joins them back together:

def clean_address_number(address):
    # Split the string into residential and door number parts
    parts = address.split('/')
    cleaned_parts = []
    
    for part in parts:
        # Strip leading zeros from the segment
        cleaned = part.lstrip('0')
        # Handle cases where the segment was all zeros (e.g., "000" becomes "0")
        cleaned = cleaned if cleaned else '0'
        cleaned_parts.append(cleaned)
    
    return '/'.join(cleaned_parts)

Test results:

• clean_address_number("007/05") → "7/5"
• clean_address_number("7/50") → "7/50"
• clean_address_number("000/00") → "0/0"

2. Regular Expression Approach (Concise)

If you prefer a more compact solution, regex can target exactly the leading zeros that need removal (those before non-zero digits, either at the start of the string or after a slash):

import re

def clean_address_regex(address):
    # Replace leading zeros that are followed by non-zero digits
    return re.sub(r'(^|/)0+(?=[1-9])', r'\1', address)

How it works:

• (^|/) matches either the start of the string or a slash
• 0+(?=[1-9]) matches one or more zeros that are immediately followed by a non-zero digit
• We replace this pattern with just the matched start/slash, effectively stripping out the unnecessary zeros

Test results:

• clean_address_regex("007/05") → "7/5"
• clean_address_regex("7/50") → "7/50"
• clean_address_regex("000/01") → "0/1" (leaves a single zero for the all-zero segment)

Key Notes #

• Both methods strictly follow your rule: only remove zeros when there's no non-zero digit preceding them
• You can tweak the all-zero handling if your database has different requirements (e.g., if "000" should be omitted entirely instead of becoming "0")

内容的提问来源于stack exchange，提问作者Jakob