Query to find postcodes with an incorrect format (no space)

Gemma Pearce

Hi All

 

Sorry if this has been covered previously, but I can't find anything! We are hitting our manic period of online donations, and it has come to light that some online donors are entering their postcodes without spaces. Whilst this isn't affecting the importing of the data onto RE, it is impacting the Gift Aid Claim Submission.

I currently run queries to pick up on overseas donors, and those where we may have missing information. I wondered if anyone had a query solution for me to ascertain those postcodes without a space so I can correct them prior to my colleague submitting the claim. I have found a solution to try to find them prior to the import in Excel, but that looks hideously tech-y!

Many thanks

 

Gemma