String Replacer

[bruno29a]

Hi @rahulgog , is it just ALEXIA 40 that you need to “clean up”?

First of all, you need to bring everything to the same case (upper case or lower case) in order to do the comparisons.

If it’s not just ALEXIA 40 but also other items, you may need to build a mapper. You can check this thread to get an idea about building the mapper:

Customer Name Matching (internal name to external name)

Hi @wethernt , you probably need to have a mapper/dictionary for this kind of matching, in addition to removing punctuation and standardizing case (upper/lower case). Looking at your sample list coming from the POS, I think a mapping for the following should be enough: [image] I used the same sample input data as you have: [image] I prepare the data with some string manipulation before doing the mapping: replaceChars(regexReplace(upperCase($column1$), " LP$", ""), ".,", "") This is basica…