Re: [libreoffice-users] Extract text from base field, place into new field

Hi Edwin,
> I need to copy the first word from an existing field and place it into a 
> new field. Is there a way to do that autoagically?
Only per macro:

1. Connect to the field in your form.
2. Read value from this field
3. Split content into an array
4. Take first entry of this array and put it to the new field.

But: You won't need the new field if you only want to extract the first 
word and won't edit the new field. You could also get the first word by SQL:

SELECT "Sentence", LEFT("Sentence", POSITION(' ' IN "Sentence")) AS 
"FirstWord" FROM "Table"

If there is only one word in "Sentence" this word wouldn't be shown. So 
the code has to be expanded:

SELECT "Sentence", CASE WHEN POSITION(' ' IN "Sentence") > 0 THEN 
LEFT("Sentence", POSITION(' ' IN "Sentence")) ELSE "Sentence" END AS 
"FirstWord" FROM "Table"

Regards

Robert
--
Homepage: https://www.familiegrosskopf.de/robert


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy