Options

Full uk address in one field

jonathan.baggaleyjonathan.baggaley Posts: 6 Bronze 2
edited May 18, 2010 10:45AM in SQL Data Generator Previous Versions
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

<?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>
:-)zz[
· Share on Twitter
Sign In or Register to comment.