How to get the text before ";" from data

[#1]

Hi

i want to extarct the frist part from the data give below

Treasury Systems;Treasury Systems;Online;Text;

Regards

Venkatesh Salla

[rwunderlich · Accepted solution]

subfield(mytext, ';', 1)

-Rob

[rajeshvaswani77]

try this,

set myvar= 'Treasury Systems;Treasury Systems;Online;Text;';

left($(myvar),1,index($(myvar),';'))