Re: [NF] UK address correctness

2014-06-25 Thread Adam Buckland
We used to use a pipe as a delimiter so that you could use all punctuation.. We used to call it the pdf (pipe delimited file) formatÅ . On 24/06/2014 18:08, "John Weller" wrote: >I think they ask you to exclude full stops and commas as they create havoc >if you are importing data as CSV :-) > >Jo

Re: [NF] UK address correctness

2014-06-24 Thread Stephen Russell
On Tue, Jun 24, 2014 at 12:08 PM, John Weller wrote: > I think they ask you to exclude full stops and commas as they create havoc > if you are importing data as CSV :-)-- > -- I get straight up xml and it is shoved into a SS report. Looks like this: AARHUS KARLSHAMN UK L

RE: [NF] UK address correctness

2014-06-24 Thread John Weller
I think they ask you to exclude full stops and commas as they create havoc if you are importing data as CSV :-) John Weller 01380 723235 07976 393631 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listin

RE: [NF] UK address correctness

2014-06-24 Thread Brian Pow
ase). Regards Brian -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Allen Sent: 24 June 2014 09:58 To: profoxt...@leafe.com Subject: RE: [NF] UK address correctness I was brought up to add county. In fact Sussex was just that when I was young, sig

Re: [NF] UK address correctness

2014-06-24 Thread Peter Cushing
Adam Buckland wrote: Working in logistics and having worked in direct marketing for my sins, I would always add the county if you have it. Postcodes can be entered incorrectly and deduced badly by software such as Anadata. When I worked for a direct marketing house for a year we got data from a

Re: [NF] UK address correctness

2014-06-24 Thread Adam Buckland
ument. The driver needs to >know the city/town. In reality our plants are usually quite close to our >top trading partners to keep freight costs down. We ship truck loads of >air inside of a lot of empty plastic bottles. :) > > > > > > > >> >> >> -Original Message-

Re: [NF] UK address correctness

2014-06-24 Thread Stephen Russell
of empty plastic bottles. :) > > > -Original Message- > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Stephen > Russell > Sent: 24 June 2014 14:32 > To: ProFox Email List > Subject: Re: [NF] UK address correctness > > On Tue, Jun 24, 2014

RE: [NF] UK address correctness

2014-06-24 Thread Dave Crozier
m http://en.wikipedia.org/wiki/List_of_generic_forms_in_place_names_in_the_United_Kingdom_and_Ireland Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Stephen Russell Sent: 24 June 2014 14:32 To: ProFox Email List Subject: Re: [NF] UK address correctness On Tue, Jun 24, 2014 at 2:58 AM, Dave Crozie

Re: [NF] UK address correctness

2014-06-24 Thread Peter Cushing
Stephen Russell wrote: I appreciate that. Is there a rule for use of the word "upon" in address as well? Looking at Kingston upon Hull HU9 5EX Well didn't know that. Kingston upon Hull is the official name for Hull http://en.wikipedia.org/wiki/Kingston_upon_Hull I'd only heard of Kings

RE: [NF] UK address correctness

2014-06-24 Thread Dave Crozier
2 To: ProFox Email List Subject: Re: [NF] UK address correctness On Tue, Jun 24, 2014 at 2:58 AM, Dave Crozier wrote: > Yes, > County and Postcode are usually placed together on the last line of > the address > > > > > > > > -- I appreciate

Re: [NF] UK address correctness

2014-06-24 Thread Stephen Russell
On Tue, Jun 24, 2014 at 2:58 AM, Dave Crozier wrote: > Yes, > County and Postcode are usually placed together on the last line of the > address > > > > > > > > -- I appreciate that. Is there a rule for use of the word "upon" in address as well? Looking at Kingston upon Hu

RE: [NF] UK address correctness

2014-06-24 Thread Allen
I was brought up to add county. In fact Sussex was just that when I was young, sigh, and not east or west Sussex. But like I said, in theory all you need is a house name or number and the post code. In practice they still want a whole lot of writing for the sake of it. Al -Original Message

RE: [NF] UK address correctness

2014-06-24 Thread Dave Crozier
oops, My should have read As Andy says, no need for county if you have the postcode. Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 24 June 2014 08:58 To: ProFox Email List Subject: RE: [NF] UK address correctness Yes, County

Re: [NF] UK address correctness

2014-06-24 Thread AndyHC
--Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Gene Wirchenko Sent: 24 June 2014 02:11 To: ProFox Email List Subject: RE: [NF] UK address correctness At 23:57 2014-06-20, "Allen" wrote: Steve: 1 Southern Cross London Road, Swanley Kent BR8 8DE Is

RE: [NF] UK address correctness

2014-06-24 Thread Dave Crozier
Yes, County and Postcode are usually placed together on the last line of the address Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Gene Wirchenko Sent: 24 June 2014 02:11 To: ProFox Email List Subject: RE: [NF] UK address correctness At 23:57

RE: [NF] UK address correctness

2014-06-23 Thread Gene Wirchenko
At 23:57 2014-06-20, "Allen" wrote: Steve: >1 Southern Cross >London Road, Swanley >Kent BR8 8DE Is bottom the "correct" layout ? I can fix it but see the data dropping incorrectly in the XML from the ERP. Looks fine to me. I usually put things on separate lines myself but it looks leg

RE: [NF] UK address correctness

2014-06-20 Thread Allen
Hi Steve Looks fine to me. I usually put things on separate lines myself but it looks legal Al -Original Message- 1 Southern Cross London Road, Swanley Kent BR8 8DE Is bottom the "correct" layout ? I can fix it but see the data dropping incorrectly in the XML from the ERP. _

[NF] UK address correctness

2014-06-20 Thread Stephen Russell
I have data dropped for address: RING CONTAINERS LTD 1 Southern Cross, London Road SWANLEY, KENT I read the BOL I am converting to SSRS and the address flows like this: 1 Southern Cross London Road, Swanley Kent BR8 8DE Is bottom the "correct" layout ? I can fix it but see the data dr