I have applied the Duplicator Remover to a simple excel file with one column of postcodes which have duplicated postcodes. I want to achieve an excel file of postcodes with no duplicates. However, when I inspect the 'unique values' output in the inspector, these value are in fact duplicated. Am I using this correctly or is there another tool I should use?
+13
You are using the correct transformer for the job, are there possibly spaces in the 'duplicates'? you can test that by calculating the lenght of the string.
Here the postcode are made of 4 numeric values and 2 alfanumeric so anything with a lenght bigger than 6 can contain white spaces and anything shorter are not valid postcodes.
+17
I agree that the "duplicate" postcodes could contain whitespaces.
In addition, in some countries, a postcode consists of digits and alphabet characters. If your postcode is so, check also case of alphabet. FME is generally case-sensitive when comparing character strings.
Takashi
my postcode list does indeed have whitespaces and digits and alphabet
i.e. PL23 4NG. Will I need to remove the whitespace for the duplicate remover to work?
Thanks
+13
Not necessarly, it depends if the whitespace between the 3 and 4 in your example is correct.
My initial idea was to remove whitespaces before and after the string so that the duplicateremover can do its work. In case that the whitespces inbetween is correct you could try a regex to remove only the whitespaces before and after the string.
+17
Additionally, if there are both uppercase and lowercase postcodes (e.g. "PL23 4NG", "pl23 4ng", "PL23 4ng" ...), consider using the StringCaseChanger to change every character to uppercase.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
