I have a column country Long that have a list of country formated such as :
I want to have in another column country short , values such as :
I have tried the following but return an error ,
Country* = LEFT([country_long];FIND("-"; [country_long];1;0)-1)
“An argument of Function LEFT has a wrong Data Type , or has an invalid value”
FIND("-"; [country_long];1;0)-1 brings back 8 has value for Germany-Europe , i cannot parse it into the LEFT function , i have tried Value() around it but same error returned.