I got a tip from @Skye Hansen‚ that might help you. Skye suggested doing
a count using LEN( and then subtract the number of characters in the job
number, providing it's consistent, and display the rest. Something like
RIGHT(Name,(LEN(Name)-11) . That's if there are 11 characters in the job
number. If you had a consistent character in the job number, you could
use another method I got from @Teale McCleaf‚.That is to use the special
character as a delimiter like in an email address.
LEFT({emailAdd...