Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I’d start from the back since, as far as I know, a city name cannot contain numbers (but it <em>can</em> contain spaces (first example I’ve found: “<a href="http://en.wikipedia.org/wiki/Weil_der_Stadt" rel="nofollow">Weil der Stadt</a>”). Then the five-digit number before that must be the zip code.</p> <p>The number (possibly followed by a single letter) before that is the street number. Note that this can also be a <em>range</em>. Anything before that is the street name.</p> <p>Anyway, here we go:</p> <pre><code>^((?:\p{L}| |\d|\.|-)+?) (\d+(?: ?- ?\d+)? *[a-zA-Z]?) (\d{5}) ((?:\p{L}| |-)+)(?: *\(([^\)]+)\))?$ </code></pre> <p>This correctly parses even arcane addresses such as “Straße des 17. Juni 23-25 a 12345 Berlin-Mitte”.</p> <p>Note that this doesn’t work with address extensions (such as “Gartenhaus” or “c/o …”). I have no clue how to handle those. I rather doubt that there’s a viable regular expression to express all this.</p> <p>As you can see, this is a quite complex regular expression with lots of capture groups. <em>If</em> I would use such an expression in code, I would use named captures (Java 7 supports them) and break the expression up into smaller morsels using the <code>x</code> flag. Unfortunately, Java doesn’t support this. This s*cks because it effectively renders complex regular expressions unusable.</p> <p>Still, here’s a somewhat more legible regular expression:</p> <pre><code>^ (?&lt;street&gt;(?:\p{L}|\ |\d|\.|-)+?)\ (?&lt;number&gt;\d+(?:\ ?-\ ?\d+)?\ *[a-zA-Z]?)\ (?&lt;zip&gt;\d{5})\ (?&lt;city&gt;(?:\p{L}|\ |-)+) (?:\ *\((?&lt;suffix&gt;[^\)]+)\))? $ </code></pre> <p>In Java 7, the closest we can achieve is this (untested; may contain typos):</p> <pre><code>String pattern = "^" + "(?&lt;street&gt;(?:\\p{L}| |\\d|\\.|-)+?) " + "(?&lt;number&gt;\\d+(?: ?- ?\\d+)? *[a-zA-Z]?) " + "(?&lt;zip&gt;\\d{5}) " + "(?&lt;city&gt;(?:\\p{L}| |-)+)" + "(?: *\\((?&lt;suffix&gt;[^\\)]+)\\))?" + "$"; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. PORegex for splitting a german address into its parts
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USKonrad Rudolph
    1. USKonrad Rudolph
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWorks like a charm for your street string, but unfortunately not for the example street. You can test it with the code example of radzio and your Regex (with escaped parts) `^((?:\\p{L}| |\\d|\\.|-)+?) ((?:\\d+ ?- ?)\\d+ *[a-zA-Z]?) (\\d{5}) ((?:\\p{L}| |-)+)$`
      singulars
      1. PO
      1. USChristian Kolb
    2. CO@Christian Because I’m an idiot. Try again, I wrote the street number range the wrong way round and didn’t make it optional. It works on the example addresses now.
      singulars
      1. PO
      1. USKonrad Rudolph
    3. COYes, now it works perfect. Thanks
      singulars
      1. PO
      1. USChristian Kolb
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload