You can translate the question and the replies:

Extracting text from a field using delimiter

Hi I have a field which contains text. Id like to extract a certain part of that text field which being "Model: 123 Customer ABC" I would like to extract only the "123" part of this field Any help would appreciated Thanks D
VQL string conversion
user
30-03-2023 21:24:49 -0400
code

2 Answers

many option there to achieve this.use any string functions , here are some examples select 'Model:123', substr('Model:123' ,position(':' in 'Model:123' )+1) , regexp('Model:123','Model:','')
user
31-03-2023 13:01:18 -0400
Hi, To extract a substring of a text in Denodo, I would use the Substring function. For example, to extract a portion of the word ‘Forsworn’, it would be Select Substring('Forsworn',0,3) and the result would be ‘For’. You can refer to [Text Functions](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/functions/text_functions/text_functions#substring-substr) in the Virtual DataPort VQL Guide for more information. Hope this helps!
Denodo Team
03-04-2023 19:36:40 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here