That's US-only though. The OP said that wouldn't be enough.
In general you're not going to be able to solve this problem. There are an awful lot of different address formats (eg compare the US, France and Japan), and there can even be different formats within a single country. Additionally, even if you could find a set of rules for each country, I know full well that the rules you'll get for the UK will be wrong, in that while they might specify what the post office *want* people to use, they will not be anything like what people *actually* use, and which *work*.
And finally, don't even consider relying on a database lookup. There are plenty of addresses in the UK which the post office's database gets wrong, or which aren't even in the database. I live at one such address, and it's very annoying when programmers who really should know better are stupid enough to trust a database generated by a government body!
| [reply] |
I just need help with validating that it looks right, so if the formula's think it is wrong, I'll just post a confirmation page, that says your address does not look correct, so we need you to validate your input is correct. So please check the box that says "Yes I verify my address is deliverable by our local post office. I will pay re-shipment costs if it is returned." Then if they check the box, I'll just override that and let them get it through.
Our members do not seem very intelligent though, for instance, one of the fields that one of our gateways asks for is: "nameoncard". Therefore my label read: "Name On Card". We had members put:
Master Card (as their name)
and: Visa Card (as their name)
Those made me LAUGH OUT LOUD, seriously, but that is how un-intelligent that most of them are. I now changed that label to: Cardholder Name. That seemed to fix the problem, so far anyhow...
I had to make our programming work for a little child, so I have my 10 year old check all my work. If he can understand it, then I figure our precious members can :).
Still, we get hundreds of helpdesk posts per week for them not understanding how some of the things work. :o( Such is life.
Anyhow, that is what I am wanting to do, is just 'Check' their entry, because I am having to manually fix some addresses because people are putting "United States" as their country field when they live in Canada, Estonia, Ireland, and one other was New Zealand.
I will not force people to change it to match any database or fomula, just make them check their entry and then promise it is correct.
Sorry for the long reply.
| [reply] |
...one of the fields that one of our gateways asks for is: "nameoncard". Therefore my label read: "Name On Card". We had members put: Master Card (as their name) and: Visa Card (as their name)
Note that in your explanation you qualified 'name' as "as their name" to make your point.
You'd probably get less problems if your label read: "Your name, as shown on the card".
so I have my 10 year old check all my work. If he can understand it, then I figure our precious members can :).
And your son's native language is?
Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
"Science is about questioning the status quo. Questioning authority".
In the absence of evidence, opinion is indistinguishable from prejudice.
| [reply] |
Most Excellent! Thank you very much... that will save me a LOT of time!
| [reply] |