Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
not "elegant", but I think it works.
var text StripOffLeftText = Left([Supplier Description],"123456789");
var number PositonOfFirstNumber = Length($StripOffLefttext)+1;
var text FirstNumber = Mid([Supplier Description],$PositonOfFirstNumber,1);
var text SecondNumber = Mid([Supplier Description],$PositonOfFirstNumber+1,1);
var text ThirdNumber = Mid([Supplier Description],$PositonOfFirstNumber+2,1);
ToNumber(
List("",
If(Contains("0123456789",$FirstNumber) and Trim($FirstNumber)<>"",$FirstNumber),
If(Contains("0123456789",$SecondNumber) and Trim($SecondNumber)<>"" and Trim($FirstNumber)<>"",$SecondNumber),
If(Contains("0123456789",$ThirdNumber) and Trim($ThirdNumber)<>"" and Trim($SecondNumber)<>"",$ThirdNumber))
)
var text StripOffLeftText = Left([Supplier Description],"123456789");
var number PositonOfFirstNumber = Length($StripOffLefttext)+1;
var text FirstNumber = Mid([Supplier Description],$PositonOfFirstNumber,1);
var text SecondNumber = Mid([Supplier Description],$PositonOfFirstNumber+1,1);
var text ThirdNumber = Mid([Supplier Description],$PositonOfFirstNumber+2,1);
ToNumber(
List("",
If(Contains("0123456789",$FirstNumber) and Trim($FirstNumber)<>"",$FirstNumber),
If(Contains("0123456789",$SecondNumber) and Trim($SecondNumber)<>"" and Trim($FirstNumber)<>"",$SecondNumber),
If(Contains("0123456789",$ThirdNumber) and Trim($ThirdNumber)<>"" and Trim($SecondNumber)<>"",$ThirdNumber))
)