String function in script

[#1]

Hello,

I have hopefully a very straightforward question that I just can't resolved. I have a particular field that displays data in the format "John Test TT - RRR" etc. I want it to be simply displayed as "John Test" so require " TT - RRR" to be removed. I've tried a range of string functions but haven't been able to get the correct answer. Thanks in advance,

Ralph

[preminqlik]

in script write

let Vname=trim(replace('John Test TT - RRR','TT - RRR',' '));

now select  it where ever you want in your sheet by front end with  "Vname"

...

Thanks for asking this question .

thank you

-premhas