Canadian Postal Code formatting

Your validation works correctly in that it will validate N5Z 3H4, N5Z3H4 or N5Z-3H4. There are old school diehards though who insist that the only valid format is N5Z 3H4, with a space, not a dash. In my case, I need to insert into a database which follows this format. Is there a bit of code that I can edit to allow only the one option?

One way you could do this is pass the text from your form input through a function, and store the resulting string in your database.

eg,

<?php
function formatpostcode($postcode) {
$removable = array("-", " "); /*any characters which may be in your postcode, other than the digits, which you need to remove*/
$p = str_replace($removable,"",$postcode);/*remove characters*/
$p = chunk_split($p,3," ");/*Insert space after every 3rd element*/
rtrim($p, " ");/*remove trailing space*/
return $p;
} 
?>

Assuming your input text from your form is from a field called 'Postcode'

In the WA DataAssist Insert server behavior, change the text which reads

((isset($_POST["Postcode"]))?$_POST["Postcode"]:"")

to

((isset($_POST["Postcode"]))?formatpostcode($_POST["Postcode"]):"")

which should apply the text formatting to your input string, before it is stored in the database

Brilliant!
Thank you very much.
I am not writing direct to the db so I had to store it in a Session Value at post but it works perfectly.
It did not occur to me that I could even do that.

Unfortunately just discovered that this line:

rtrim($p, " ");/*remove trailing space*/

is not working and each entry has a space after it.

Fixed.
changed line to:

$p = rtrim($p);/*remove trailing space*/

Thanks again for your help!