3 Replies Latest reply: Jun 26, 2014 1:38 PM by Clever Anjos RSS

    Need a solution for REPLACE

      So the data I was given has some spelling errors, so as a temporary fix I need to group the errors together until the system that holds the data is fixed.

       

      Replace work for most of it until I came to abbreviations.

       

      So the script is:

       

      Replace(Replace(Replace(AccountGroup, 'Admininstration', 'Administration'),'Maint', 'Maintenance'), 'Mangemnt', 'Management')AS AccountGroup,

       

      However I get a group called 'Maitenance', and a group called 'Maintenanceenance' since it is replacing the "Maint" of the correctly spelled group as well.

       

      Is there an easy solution to fix this or another way of going about it?

       

      Thanks,