I have a solution that has two fields of data that need to be standardised, for example;
Field Name: Town
Data: Soller, Søller, Sólle, Sóller
I would like these to return = Soller
Field Name: Property Type
Data: House, Villa, Mansion, Finca, Detached House
I would like these to all return = Villa
I understand I will end up with two new fields showing the final data, this is fine and what I need.
I can provide the whole soulition for you to add this autolook up