Create a field extracting 'n' characters from another field

[#1]

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

[Gysbert_Wassenaar · Accepted solution]

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.