Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.