Create a field extracting 'n' characters from another field

Fri, 04 Jan 2013 17:27:21 GMT

Hi,

I have a table with a field called 'description', it is a text field.

I would like to create another field into the same load called 'first_word'.

I suppose I need a function to count the position of the first blank, and then using a function to extract from the first position to the position counted before but how should I write so?.

LOAD

description

EXTRACT(description, FIND&COUNT(BLANK)) as first_word

from...

Thanks

Re: Create a field extracting 'n' characters from another field

Gysbert_Wassenaar — Fri, 04 Jan 2013 17:41:55 GMT

Try: subfield(description,' ',1) as first_word

It treats description as a list of strings separated by a space ' '. It returns the string before the first space because of the 1 as the last parameter.

topic Re: Create a field extracting 'n' characters from another field in QlikView

Create a field extracting 'n' characters from another field

Re: Create a field extracting 'n' characters from another field