Multiple Character delimiter in formula

Question

I'm trying to cut out the last 5 digits of a Serial Number if the length is greater than 11, and I'm also trying to add a - after the third digit if the type is set to Master... What I have so far:

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 = Right($short, $Prefix);
var text Result = If([Type]= "Master", $prefix&"-"&$mini,$Short);

This works great except for $mini.

if it's 1234567890, I want mini to be 4567890, since prefix would be 123.

------------------------------
Ryan Stanford
------------------------------

XavierFan · Answer

With the formula you posted above - it returns the following:

So looks like it's behaving as expected? When Type = "Master", the prefix is 123, with mini being 4567890.

1)  With Number = 1234567890, Type = "Master"
Result = 123-4567890

2)  With Number = 1234567890, Type <> "Master"
Result = 1234567890

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

Sign up

Login to the community