I have a list of companies that I have to cross to another list of companies by name.   As you can imagine, the main problem with this task is that usually, the companies' names end with letters as LLC in USA or SA or SL in Spain.   The problem with this topic is that in some cases LLC can be written LLC or L.L.C., so that I need to delete the dots, and in this case, if I use TRANWRD or COMPRESS, after deleting the dot, the process is including an space, so I obtain L L C when I need to obtain LLC   Some examples of my code: OPTION 1: tranwrd(tranwrd(compbl(upcase(NAME)),'.',''),',','') as NEW_NAME OPTION 2: compress(compbl(upcase(NAME)),',.') as NEW_NAME Any ideas on how can I resolve this matter? ... View more