If so (and assuming that you don't want the substrings to include any of the ":"s), then the first 3 formulas are quite simple. The 4th is a bit trickier.

// formula 1

Split ({Customer.FullName}, ":") [ 1 ]

// formula 2

Split ({Customer.FullName}, ":") [ 2 ]

// formula 3

Split ({Customer.FullName}, ":") [ 3 ]

// formula 4

Local StringVar t;

t := Split ({Customer.FullName}, ":") [ 3 ];

if InStrRev (t, "-") > 0 then

Val (Mid (t, InStrRev (t, "-") + 1))

else

0

If there could be fields that do not contain the two ":"s (say, something like "ACME:25001"), that complicates things a bit. The formulas above will produce errors if there aren't two (or more) ":"s in a string.

James