wildcard in dimension

[capriconuser]

i have a column and in that column i have some data like this 

CO2345

DF34234

now i want if there is CO in starting then i want to rename as CO  and if data has DF at starting then i want only DF in data like this 

CO

DF

what should  i do 

[pradosh_thakur · Accepted solution]

if(left(field_name,2)='CO','CO',IF(LEFT(field_name,2)='DF','DF',field_name))

[agni_gold]

if(wildmatch(Column_Name , 'CO*') , 'CO' ,
if(wildmatch(Column_Name , 'DF*') , 'DF' ,
Column_Name
))

[tresesco]

Or this:

=Pick(WildMatch(Dim,'CO*', 'DF*'), 'CO','DF')