如何编写匹配A-J行1-10列单元格的正则表达式？

Nice catch on the edge cases here—matching Excel-like cells with A-J columns and 1-10 rows definitely needs precision to avoid false matches. Let's break down how to optimize this regex to be cleaner and more reliable.

First, let's recap the exact rules we need to enforce:

• Columns: A-J (case-insensitive, so A/a through J/j)
• Rows: 1-10 (no leading zeros, so 01 is invalid; 10 is allowed, but anything above 10 or below 1 is out)
• The cell reference must be a standalone token (so it can't be part of a longer string like A100)

Your second regex works for most cases, but the logic for handling 10 is a bit convoluted with the lookbehind. Let's simplify this with a more straightforward branching approach that's easier to read and maintain.

Recommended Clean Regex #

If you're matching the cell as a full string (e.g., validating user input), use:

^[Aa-Jj](?:[1-9]|10)$

If you're searching for the cell within a larger block of text (and need to ensure it's not part of a longer word/number), use whitespace-aware boundaries:

(?<!\S)[Aa-Jj](?:[1-9]|10)(?!\S)

Breakdown of the Pattern #

Let's break down each part to see why this works:

• (?<!\S): Negative lookbehind that ensures the character before the cell is either whitespace or the start of the string (prevents matches like XA1 or A100 where the cell is part of a longer token)
• [Aa-Jj]: Shorthand for matching A-J (uppercase or lowercase) — way cleaner than listing every letter twice!
• (?:[1-9]|10): A non-capturing group that handles the row logic:
  • [1-9]: Matches any single digit from 1 to 9
  • |10: Or explicitly matches the number 10 (since it's the only two-digit valid row)
• (?!\S): Negative lookahead that ensures the character after the cell is either whitespace or the end of the string (prevents matches like A1B or A100)

Bonus: Case-Insensitive Shortcut #

If your regex engine supports the i (case-insensitive) modifier, you can simplify even further:

(?<!\S)[a-j](?:[1-9]|10)(?!\S)

Just add the i flag, and it will match both uppercase and lowercase columns automatically.

Test Cases #

Let's verify this works for your requirements:
✅ Matches: A1, a1, J9, e10, E10
❌ Doesn't match: A100 (extra digit), A30 (row >10), P7 (column outside A-J), A01 (leading zero on row)

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