| Author |
Message |
jonathan.baggaley
Joined: 20 Apr 2010
Posts: 5
Location: Berkshire
|
 Posted: Tue May 18, 2010 3:45 pm Post subject: Full uk address in one field |
 |
|
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: |
<?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>
|
|
|
| Back to top |
|
 |
|
|
All times are GMT + 1 Hour
|
| Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
