I have 2 columns of address which are not exact duplicates , but I want to pass a code that if the first 5 characters of column 1 address matches the first 5 characters of column 2 address , then its true if not it would be false.
Here is how my data is now
Column 1
2310 Aldergrove Ave
3901 Castle Hayne
Column 2
2310Aldergrove
3901Castle
So for both this since the first 4 characters match I want my third columns to say True , True.
Aucun commentaire:
Enregistrer un commentaire