Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i want to extarct the frist part from the data give below
Treasury Systems;Treasury Systems;Online;Text;
Regards
Venkatesh Salla
subfield(mytext, ';', 1)
-Rob
try this,
set myvar= 'Treasury Systems;Treasury Systems;Online;Text;';
left($(myvar),1,index($(myvar),';'))