Hi,
I am glad that you were able to figure it out.
If I want to manipulate or transform values of fields with **text** datatype, I would use the necessary [Text Processing Functions](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/text_processing_functions) provided by Denodo Platform such as [SPLIT](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/text_processing_functions#split), [SUBSTRING](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/text_processing_functions#substring-substr) etc.
Hope this helps!