Hello,
That can be achieved using two functions available in Denodo - **[SPLIT](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/functions/text_functions/text_functions#split)** and **[REGEXP](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/functions/text_functions/text_functions#regexp)**.
Using **SPLIT()** you will get the country and the country code divided into rows inside an array, therefore you will have then to select the array element that matters to you, following the example below would be field[0], which is a register. After that, you would need to project the subfield of the register so that you get a text field.
```
SELECT (field).string from (
SELECT field[0] from (
SELECT SPLIT(' ', 'India (IN)') as field))
```
The same can be achieved using the **REGEXP** function. This function is used to replace a value with another based on a regular expression, so the idea here would be to replace ‘(IN)’ with ‘ ‘ and you would also achieve the same result.
Hope this helps!
