Everything before last "-" in a string 1

[mbDutch]

Hello (again) -

I am in need of a formula that returns everything in a string that comes before
the last - (dash). For instance, if a part number is EX-P002-AB I want it to return
EX-P002. If a part number is EC-V003 I just want it to return EC.

Many thanks in advance,

Marco

 

[lbass]

stringvar x := {table.string};
if instr(x,"-") <> 0 then
left(x,instrrev(x,"-")-1) else
x;

-LB

 

[mbDutch]

Perfect - thank you!