I am new to BODS which is really nice tool. I am learning how to use its dictionary. I have come across one challenge and to see if I can get help.
I have a Firm field in my table that needs to be cleansed. Dictionary has been a great help except in one situation. Here it is,
Input : Millard I n c. Converts to Millard I N C. I want Millard Inc.
So I tried entering I n c to dictionary with
convert to standard
but I still get I N C.
Same with l l c.
Any help would be highly appreciated.