Forum Discussion
DonLarson
3 years agoQrew Elite
Two fields would be needed
Pre Dash, Text Field
Dash, Formula Text Field
This should work for the formula
// Create Dash Text Output format XX-ABCD....-XX
// Capture Left Two Characters
var text LeftTwo = Left([Pre Dash], 2);
// Capture Right Two Characters
var text RightTwo = Right([Pre Dash], 2);
//Capture 1st part of the middle
var text MiddleOne = NotLeft([Pre Dash], 2);
// Capture Full Middle
var text Middle = NotRight($MiddleOne,2);
// Create the Output
var text Output = List("-", $LeftTwo, $Middle, $RightTwo);
$Output
------------------------------
Don Larson
------------------------------
Pre Dash, Text Field
Dash, Formula Text Field
This should work for the formula
// Create Dash Text Output format XX-ABCD....-XX
// Capture Left Two Characters
var text LeftTwo = Left([Pre Dash], 2);
// Capture Right Two Characters
var text RightTwo = Right([Pre Dash], 2);
//Capture 1st part of the middle
var text MiddleOne = NotLeft([Pre Dash], 2);
// Capture Full Middle
var text Middle = NotRight($MiddleOne,2);
// Create the Output
var text Output = List("-", $LeftTwo, $Middle, $RightTwo);
$Output
------------------------------
Don Larson
------------------------------
RhondaJones
3 years agoQrew Cadet
Excellent, thank you.
------------------------------
Rhonda Jones
------------------------------
------------------------------
Rhonda Jones
------------------------------