Re: Multiple Character delimiter in formula

Ok - then you'd want to change your mini line as follows - to use "NotLeft", and get the remainder of the text after excluding the leftmost 3 characters.

var number AWBLength = Length([Number]);
var number Cut = 5;
var text Short = If($AWBLength > 11,(Left(ToText([Number]),$AWBLength - $Cut)),[Number]);
var text Prefix = If([Type]="Master", Left(ToText([Number]),3),"");
var text mini = NotLeft($short, 3);
var text Result = If([Type]= "Master", $prefix&"-"&$mini,$Short);


------------------------------
Xavier Fan
Quick Base Solution Provider
http://xavierfanconsulting.com/
------------------------------