You can translate the question and the replies:

Creating a new column in derived view

Hi team, I created a derived view from two base views. In this derived view I want to create a new column doing the following transformations to the data: I currently have this column *existing column* street: *value:* 'streetname123' I want to create a new column like this: *existing column* street: *value:* 'streetname' *new column* housenr: *value:* '123' Im currently using the new field option within the edit tab trying to execute the following pseudocode: CASE WHEN existing_column.column_name CONTAINS 0 to 9 THEN take number (or number pair) and store it into the new column END
derived view Data Quality
user
12-04-2017 04:27:29 -0400
code

1 Answer

Hi, I would use REGEXP function in Virtual DataPort to remove the characters or numbers from a string. For example, you could remove characters from a field by using something like this: ``` SELECT REGEXP('streetname123','[a-zA-Z]','') as housenr, REGEXP('streetname123','[0-9]','') as street FROM dual() ``` You could refer to the community question [Special character](https://community.denodo.com/answers/question/details?questionId=90670000000XczwAAC&title=Special+character) to know about using REGEXP function . Hope this helps.
Denodo Team
12-04-2017 08:49:20 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here