Comparing two uk postcode values for match and part match ignoring spaces and case

Question

I would like to compare two uk postcode strings in a ms access database vba function.

I want to first identify if the postcodes match. Ignoring and case sensitivity or spaces between the incode and outcodes if they are present in either postcode strings.

If they don't match entirely then I would like to return the number of characters that do match

E.g. A841JD and A84 1XJ would return 4 and AB41 1JD and Ab411jD would return true.

How would I go about coding this. I get stuck when taking out any space characters to compare on with for next loops on comparing byte arrays.

Can you please add your code snippet here, so that SO can try to help you out — Siva, Feb 02 '16 at 12:14

score 0 · Answer 1 · answered Feb 02 '16 at 12:22

0

Try this:

if replace(lcase(range("A1").value)," ","") = replace(lcase(range("A2").value)," ","") then
    'Do something
end if

answered Feb 02 '16 at 12:22

RobK

207
1
5
14

Great! Could you please mark your question as answered, to keep this website clean? :) – RobK Feb 02 '16 at 15:00
Please don't forget to mark the question as answered! – RobK Feb 04 '16 at 11:56

Comparing two uk postcode values for match and part match ignoring spaces and case

1 Answers1