Postcode validation

Postcode format

L - Letter N - Number

LLNN NLL
and
LLN NLL

Does anyone know what validation/formula I need to use, so that users can only enter a postcode in the same format as the 2 variations above?

This is some event code that I use

Please Login or Register  to view this content.

thanks.

Is it possible to use a formula or is using code the only way i will be able to include validation?

thanks.

Is it possible to use a formula or is using code the only way i will be able to include validation?

those are the 2 most common patterns that will be entered, but if it's possible to include other variations in the validation then i would like to do that.

Hi,

Bob's code does that, can't you use this.

@Bob, there's also another one - "[A-Z][A-Z]#[A-Z] #[A-Z][A-Z]"

ok thanks, I'll try it and see.

Originally Posted by Kyle123

Hi,

Bob's code does that, can't you use this.

@Bob, there's also another one - "[A-Z][A-Z]#[A-Z] #[A-Z][A-Z]"

Where is that one Kyle?

Originally Posted by daddylonglegs

The postcode for New Scotland Yard is in that format - SW1H 0BG

There are other London postcodes of that type too WC1H.....etc.

I get a feeling I have been round this loop before

Good Link DLL

I only know because something I did broke when someone used a London postcode and everything came crashing down...(well people whining anyway!! )

Hi,

I have this working perfectly in one column however i have 2 columns with 2 different postcodes, how can i get this formula to work on 2 separate columns?