Full uk address in one field

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

Full uk address in one field

Postby jonathan.baggaley » Tue May 18, 2010 3:45 pm

Just save the following as FullAddress.xml in your Red Gate\\SQL Data Generator 1\\Config folder then fire up the generator...

uk files in http://sdggenerators.codeplex.com/releases/view/17693


Code: Select all
<?xml version="1.0" encoding="iso-8859-1"?>
<generators>
   <generator
      type="RedGate.SQLDataGenerator.ExpressionGenerators.RegexpGenerator"
      name="Full UK address"
      description="Full UK address in 1 field"
      category="Geographical">

      <property name="Expression">([1-9][0-9][0-9]?) (North |East |West |South |||||||||||)(Green |White |Rocky

||||)(Nobel|Fabien|Hague|Oak|Second|First|Cowley|Clarendon|New|Old|Milton)

(Way|Street|St.|Avenue|Road|Parkway|Freeway|Drive|Boulevard|Blvd.), (($"UKPostTown.txt")|($"UKCity.txt")), ($"UKCounty.txt")

(AB|B|BA|BB|BD|BH|BL|BN|BR|BS|BT|CA|CB|CF|CH|CM|CO|CR|CT|CV|CW|DA|DE|DG|DH|DL|DN|DT|DY|E|EC|EH|EN|EX|FK|FY|G|GL|GU|H|HG|HP|HR|HS|HU|HX|

IG|IM|IP|IV|KA|KT|KW|KY|L|LA|LD|LE|LL|LN|LS|LU|M|ME|MK|MK|N|NE|NG|NN|NP|NR|NW|OL|OX|PA|PE|PH|PL|PO|PR|RG|RH|RM|S|SA|SE|SG|SK|SL|SM|SN|S

O|SP|SR|SS|ST|SW|SY|TA|TD|TF|TN|TQ|TR|TS|TW|UB|W|WA|WC|WD|WF|WN|WR|WS|WV|Y|ZE)([1-9]|[1-9][0-9]) [1-9][A-Z]{2}</property>

      <matches field="Address" score="40" minlen="19"/>
      <matches field="FullAddress" score="39" minlen="19"/>

      <type type="string"/>
   </generator>
</generators>
jonathan.baggaley
 
Posts: 5
Joined: Tue Apr 20, 2010 4:56 pm
Location: Berkshire

Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests