Forum Discussion

RyanStanford1's avatar
RyanStanford1
Qrew Captain
5 years ago

Multiple Character delimiter in formula

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: ...
Formulas and functions
RyanStanford1's avatar
RyanStanford1
Qrew Captain
That example wasn't the best... as if say it's a 34587594513 will not work out as intended, where I want it to be 345-87594513

------------------------------
Ryan Stanford
------------------------------
XavierFan's avatar
XavierFan
Qrew Cadet
5 years ago
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/
------------------------------
  • RyanStanford1's avatar
    RyanStanford1
    Qrew Captain
    5 years ago
    As I was awaiting response, I came to the exact same solution.

    Thank you very much, Xavier!

    ------------------------------
    Ryan Stanford
    ------------------------------
  • RyanStanford1's avatar
    RyanStanford1
    Qrew Captain
    5 years ago
    I've done some further research, and another option is to use the split() function.

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