LeftWords WordCount

[Frink1234]

I am trying to use SetField to set all but the last 9 words of one field to another. I have tried using

Leftwords(Text_Field - 9) didn't work.

Then I tried

LeftWords(Text_Field;WordCount(Text_Field) - 9) Nope.

What am I doing wrong?

[Raybaudi]

The first is evidently wrong...

but the second one is correct and must work !

[Frink1234]

Oh, I was right with the second script! The reason it wasn't working - I was trying to use it on a calculated field and it was coming back with a numeric value. So I cut and pasted the text into a global text field first and then set this field to the target field. There might be a more elegant solution but this works.