Posted on 2011-10-18
I will be getting a list of company names.
I want to abbreviate certain string in the name to choice 1.
I may find either the full string which I want to shorten to choice1. Alternatively they may have used choices 2, 3 or 4 which must be changed to choice1.
For example Rentenfonds and Rtfd should be changed to Rentfds.
Where a choice1 abbreviation has different meanings in the same market it is ambiguous and should be ignored. For example CP has 2 meanings in Brazil and should be ignored.
Where a choice1 abbreviation has different meanings in one market and a different meaning in "ALL" then expand it according to it's meaning for "ALL" for every market besides the one where it has a different meaing.
For example TR should be expanded to Trust for all marekts besides UK. In the UK it should be expanded to Total Return.
Full Name Choice 1 Choice 2 Choice 3 Choice 4 Market
Companies Cos ALL
Credit Suisse CP Curto P Brazil
Curto Prazo CP Brazil
Corto Plazo CP Spain
Conta de referencia CR Brazil
Credito Privado CrdPri C P Brazil
Credit Crdt ALL
Crecimiento Crec Spain
Rentenfonds Rentfds Rentfds Rentfd Rtfd Germany
Republic Rep Repub ALL
Reserve/Reserves Res Rsv(s) Rsrv(s) ALL
TR Trust ALL
TR Total Return UK