Delete Last word ACTION in text attribute

Sergej

Hi!
Is there an action that can delete last word in text files attribute?

If  LENGTH (BO.BO)>35 Then "Delete last word"

Sergej

I meant text field attribute.

aware_support

Use a combination of INDEX_OF and SUBSTRING functions

Sergej

Thanks!
Could you give more examples please.

INDEX_OF
Returns an integer constant indicating the index of the first string
within the second string. For example, INDEX_OF(‘fox’, ‘red fox’)
returns 5.

Why 5?

I need to delete last word in each cell of the column containing from 2 to 7 words in each cell if length of symbols in cell > 35 symbols.

aware_support

Actually, there's one function missing from our text library LAST_INDEX_OF that should return the index of the last occurrence of the character. If it existed the rule would be:

SUBSTRING(YourString, 0, LAST_INDEX_OF(YourString, ' '))

Can you write a plug-in that implements LAST_INDEX_OF? If not you have to wait for 5.2

Sergej

Ок, thanks i will wait/

juicer

While you are waiting for version 5.2, try this

bo.attribute=WORDS_FROM_LEFT(bo.attribute,WORD_NUMBER(bo.attribute)-1)

Sergej

juicer, Thanks! I will try.

Still waiting for 5.2. Will it be published till New Year ?