Hi,
I'm glad you were able to find a solution! I was able to implement the functionality you described in your question. If you have a base view that has a column containing the text you described, you can create a new selection view over it. In the output tab when editing this new view, you can create a new field and enter the following field expression:
`case WHEN (instr(<base view name>.<field name>, ';') > -1) THEN substring(regexp(<base view name>.<field name>, '.*(?=; \d)|(?<=; \d+\b).*', ''), 2) ELSE NULL END`
The `regexp` function will get rid of everything before the semicolon if the semicolon is followed by a digit. It will also get rid of everything after the number that we are hoping to extract. So far our text looks something like: `; ####`
The `substring` function will finish the job by getting rid of the semicolon and space character leaving us with the number we wanted to extract.
For more information on Denodo's text processing functions, you can visit the [Text Functions](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/functions/text_functions/text_functions) section of the VQL Guide.
Hope this helps!
